Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare a value to many other values
I want to check if a certain value (cell) is equal to any of a number of
cells (N5:AQ32). If the value equals one or more of the cells i want it to return "1", if not return "0". Thanks in adwance. Viktor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare values | Excel Discussion (Misc queries) | |||
Compare Values | Excel Worksheet Functions | |||
Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
compare values | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |