Re: Formula To Calculate Duplicate Items With Criteria

Domenic,

Thank you for your reply. My apologies. I forget to mention about another criteria.There is an addition column with an error points (if any) for the particular work item#. I need the formula to incorporate to arrive at the results only if there is an error points. The minimum error point is 0.25. Example is as below:

Work Item#

1234567

1234568

1234567

DS/WU

DS

WU

DS

Error Points

0.25

0

1

For the above example, the result should be Work Item# 1234567, duplication is 2 times, DS/WU is DS 1 time, WU 1 time. All criteria is same as previous post but the formula should only populate the values if there is an error point assigned to that work item#.

Thank you for the time and effort.

Fo