Hi

XL2K.

I have a dynamic range of numbers (Sheet 2 in Col F commencing at Row
12).

I also have a dynamic master list of numbers containing many
duplicates (Sheet 1 in Col B commencing at Row 2).

What I would like to do is look at each number in the range on Sheet
2, find the first occurence in the range on Sheet 1 and place the
number 1 in the adjacent cell in Col A. Any further matches of that
number are to be ignored.

Also, the numbers in the range in Sheet 2 will always be in the range
in Sheet 1.

Would someone be kind enough to assist.

Cheers

Bob