duplicate detection formula or vba macro

[rn119]

I have a table in the following manner (let's say they are positioned from columns A to D)

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Ref #[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]407[/TD]
[TD]INVTF[/TD]
[TD]100900[/TD]
[TD]Paris[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]789030[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]541001[/TD]
[TD]Madrid[/TD]
[/TR]
[TR]
[TD]800[/TD]
[TD]KLUMM[/TD]
[TD]103990[/TD]
[TD]Hong Kong[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]102030[/TD]
[TD]Toronto[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]100900[/TD]
[TD]Paris[/TD]
[/TR]
[TR]
[TD]750[/TD]
[TD]JSIUI[/TD]
[TD]130990[/TD]
[TD]Montreal[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]657899[/TD]
[TD]Miami[/TD]
[/TR]
</tbody>[/TABLE]

100900 occurs twice here under two different IDs (i.e., 407 and 800). Is there a formula or a macro that I can use that will write that the Ref # exists in different ID sequences or a formula that will check for dups after the second iteration?

 

[Fluff]

If you want to suggest changes to the site, then you need to start a thread in the "About This Board" section.