Listing unique values without Pivot Table.

In JBeaucaire's attached file, if B3 has data and any cell from B4 down is empty, it will just keep going down the row until it finds more data

The data I am using sometimes starts with a blank cell or two in cell B3, is there a way of error checking down the column, say 4 rows, to see if there is data below an empty B3 cell

Bob

Unique values_no pivot.xlsx

Brilliant,

From the limited testing it seems to work

Thank you very much