Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ifcount to compare two columns?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Two Columns | Excel Worksheet Functions | |||
compare 2 columns | Excel Worksheet Functions | |||
multiple criteria ifcount() | Excel Worksheet Functions | |||
Need a help with the IF/ IFCOUNT function | Excel Worksheet Functions |