Thread
:
ifcount to compare two columns?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
ifcount to compare two columns?
Try this:
=--ISNUMBER(MATCH(B1,A$1:A$1443,0))
Copy down as needed
Biff
"Excel Function Application" <Excel Function
wrote in message
...
I have two columns range(A1:B1443). All I need to do is take the value of
B1
and compare it to every item in column A. If this value appears in column
A
at all, I would like C1 to return a value of 1, and if it does not appear
I
would like C1 to return a value of 0.
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko