I have a worksheet with salesmen's initial in column F and relevant project data across the row. The workshhet is in chronological order. I would like to copy this data on another worksheeet, but re-group it by salesperson.
I am using the following array formula:
=INDEX($D$3:$D$150,MATCH(LARGE(COUNTIF($F$3:$F$150,">="&$F$3:$F$150),ROWS($F2:$F2)),COUNTIF($F$3:$F$150,">="&$F$3:$F$150),0))
This formula copies project name from column D.
The problem: For the same salesman in rows e.g. 5,9,16,23, Column D copies duplicate entries in four consecutive rows. So Rows 1,2,3 and 4 all have the same project name for that salesman.
Can someone plese help?
thanks in advance.
Allen
Bookmarks