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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare a value to many other values
Try
=IF(COUNTIF(N5:AQ32,A1)0,1,0) Mike "Viktor" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare a value to many other values
another one:
=--(COUNTIF(N5:AQ32,A1)0) The -- stuff changes True to 1 and false to 0. Viktor wrote: 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 -- Dave Peterson |
Reply |
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) |