M
martin
I have 2 colums of numbers that I need to match with each other
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
How do you want to see matches? A column showing if A matches B, B matches
A, either, highlighting, or what?
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
A, either, highlighting, or what?
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
M
martin
Hi The 2 colums of numbers are on differant sheets so I would like it to say
true if the numbers on sheet 1 match the numbers on sheet 2 if they dont then
false to show
true if the numbers on sheet 1 match the numbers on sheet 2 if they dont then
false to show
T
Teethless mama
=COUNTIF(Sheet2!$A$1:$A$100,Sheet1!A1)>0
Adjust your range to suit
copy down as far as needed
Adjust your range to suit
copy down as far as needed
B
Bob Phillips
So just use
=MATCH(A1,Sheet2!A:A,0)
in B1 and copy down
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
=MATCH(A1,Sheet2!A:A,0)
in B1 and copy down
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
M
martin
Thanks
Teethless mama said:=COUNTIF(Sheet2!$A$1:$A$100,Sheet1!A1)>0
Adjust your range to suit
copy down as far as needed
S
Steve
Can you send me a sample of it? I might be able to help