| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
I need to make a comparison formula. (i.E
If anything in column A = cell C2 then 'pass','fail' Anybody know how do do that.. I already know how to do if Cell = Cell but not a whole column = cell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
=IF(COUNTIF(A:A,C2)<0,"Pass","Fail")
"joker_r_me" wrote: I need to make a comparison formula. (i.E If anything in column A = cell C2 then 'pass','fail' Anybody know how do do that.. I already know how to do if Cell = Cell but not a whole column = cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
