Hi,

Hope you can help. Had a search around but couldn't quite find the
answer to this problem within the newsgroup.

I have a set of data, spanning just over 60,000 records in Excel.
This is two columns (UniqueName and LineItem). I need to be able to
show that the UniqueName field doesn't appear twice against any
LineItem.

Therefore the formula would need to show any examples where different
LineItems contain the same UniqueName. I've enclosed a set of data
below to 'test' this on.

UniqueName Line Item
IR0000027446-10842 OR11062
IR0000027512-15298 OR15648
IR0000027532-14440 OR16882
IR0000027627-20023 OR16677
IR0000027632-21155 OR19324
IR0000027682-22227 OR21586
IR0000027829-28170 OR28501
IR0000027842-25719 OR23127
IR0000030260-7501 OR4117
IR0000030435-15602 OR13148
IR0000027842-25719 OR132
IR0000030478-16840 OR18805

So in the above data set it would need to highlight that
IR0000027842-25719 appears against OR132 + OR23127

Appreciate your help on this.

Thanks, Al.