Find 1st occurence of value in Range 1 in Range 2
 

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

Find 1st occurence of value in Range 1 in Range 2
 

in sheet1, A2 put in the formula
=if(countif($A$1:A1,B2)=0,1,"")
then drag fill down the column.

You said all numbers in Sheet1 would be found in Sheet2, but on the chance
they would not

=if(countif(Sheet2!$F:$F,A2)=0,"",if(countif($A$1: A1,B2)=0,1,""))

--
Regards,
Tom Ogilvy



"Ozbobeee" wrote in message
...
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