ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Help (https://www.excelbanter.com/excel-discussion-misc-queries/136205-formula-help.html)

joker_r_me

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

BoniM

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

All times are GMT +1. The time now is 07:15 PM.