Check whether some number exist in the column ... T? F?

Check whether some number exist in the column ... T? F?

A1 = 5
A2 = 3
A3 = 1

Check for number 7 answer False
Check for number 1 answer True

Icing on the cake .... how many times does it exist?

6 hours ago

by garbo744...

Member since: May 27, 2008

 

Best Answer - Chosen by Asker

To check if the numbers 7 or 1 appear in A1:A50:

=IF(COUNTIF(A1:A50,7)>0, "True", "False")
=IF(COUNTIF(A1:A50,1)>0, "True", "False")

Otherwise, just to count the occurrences:

=COUNTIF(A1:A50,7)
=COUNTIF(A1:A50,1)