Hi all,

I am looking for a way to list all unique entries from for e.g. row b over all sheets in my workbook.

The idea however is to have this continually updating and everytime a new unique value us added into the row it will automatically appear.

This is going to be coupled with COUNTIF to feedabck the number of times used.

Thanks,

Ben.