I have a table in the following manner (let's say they are positioned from columns A to D)
<tbody>
</tbody>
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?
ID | Name | Ref # | Location |
407 | INVTF | 100900 | Paris |
789030 | New York | ||
541001 | Madrid | ||
800 | KLUMM | 103990 | Hong Kong |
102030 | Toronto | ||
100900 | Paris | ||
750 | JSIUI | 130990 | Montreal |
657899 | Miami |
<tbody>
</tbody>
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?