I have found my answer.
Then I hit Ctrl, Shift, Enter to confirm the formula and copy it down.Code:=INDEX(SalesRep,SMALL(IF(SALESREP=B8,Row(SalesRep-Row(B$2)+1),COUNTIF(B$8:B8,B8)))
|
Results 1 to 2 of 2
Threaded View
|
Click Here to Expand Forum to Full Width |