I am having some trouble taking the formulas you created and implementing them into my sheet.

The worksheet my data is in is named: Nov Data

I have data down to line 1043.

So would not the formula look like the following:

=IF(ROWS($B$1:$B1)>COUNTIF(NOV Data!$C$2:$C$1043,$B$1),"",INDEX(NOV Data!$B$2:$B$1043,SMALL(IF(NOV Data!$C$2:$C$1043=$B$1,ROW(NOV Data!$B$2:$B$1043)-3-ROW(NOV Data!$B$2)+1),ROWS($B$1:$B1))))

When I enter the above and click CTRL+SHIFT+ENTER I get a pop up box that says: Update Values: Data

What am I doing incorrectly?