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?
