Bit left field perhaps,
Basically we have a table containing some 960 lines of information, only one column contains 'unique ID'. Information is updated via a simple UserForm.
Same userform contains a couple of reports (interesting stats more than anything). What I would like to do is have a dynamic(?) ListBox that shows any duplicates contained in my one unique ID column (column A). Or perhaps a table on another sheet that the ListBox refers back to?
Unusually in our operation it is ok to have duplicated unique values, provided we review these regularly. Hence the need to have a view showing these records (taking no action) so an appropriate employee can review and make a decision from there.
Hopefully that makes sense!