Home |
Search |
Today's Posts |
#1
|
|||
|
|||
checking celll in column
Hi I need help I want to look for a cell in column if we find the cell in the column “ the value of the cell” write 1 if not write 0 For example – I have A1 cell which have inside number I want to check if that number in the rang of C1;C100 if true 1 false 0 I do it like that =IF(C3=sheet1!C3:C16;1;0) but it doesn’t work cuz it check in all the column not cell by cell in the column Thnx -- withblue ------------------------------------------------------------------------ withblue's Profile: http://www.excelforum.com/member.php...o&userid=23767 View this thread: http://www.excelforum.com/showthread...hreadid=374147 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |