You can do it with a rather long formula

=IFERROR(INDEX($B$2:$B$12,AGGREGATE(15,6,(ROW(B$2: B$12)-ROW($B$2)+1)/ISNA(MATCH($B$2:$B$12,$C$2:$C$12,0)),ROWS($D$22) )),"")

Attached Files

Book11_Purfleet.xlsm (19.8 KB, 9 views)

Thank you for the help. When I first pasted data into this sheet it did not work correctly and it seems from the formula that this was limited up to the 12th row. My data may be up to 1000 rows so I changed the 12's in the formula to 1000. This created another problem as the empty rows now showed up as 0's. Being that none of my data will ever have a value of zero I just put a IF 0 then "". I imagine there's a better way to fix this but this seems to work fine. Thanks again.