Create a helper column D
In D2: =COUNTIF($C$2:C2,C2)1
copy all the way down

In E2:
=IF(ISERR(SMALL(IF((Month="Jan")*(Item="B")*(Helpe r=TRUE),ROW(INDIRECT("1:"&ROWS(Month)))),ROWS($1:1 ))),"",INDEX(Salesperson,SMALL(IF((Month="Jan")*(I tem="B")*(Helper=TRUE),ROW(INDIRECT("1:"&ROWS(Mont h)))),ROWS($1:1))))

ctrl+shift+enter, not just enter
Copy down until you see blank


"Scott Halper" wrote:

I have the following data set:

Month Item Salesperson
Jan B AA
Jan B AA
Jan B AB
Jan B AB
Jan B AC
Feb B AB
Feb B AB
Feb B AA

I am trying to write a formula that will count the number of multiple
sales by a salespersons that have had for Item B. In this example for
Jan and Item B it would be two (Salesperson AA & AB both had multiple
sales).

Thanks for the help.