Compare values in a column

[chatty56]

I have a column of about 1000 rows with either a value of "OK" or Name?" in the cells.
In a cell at the top of the column I want to return "OK" if all the cells have "OK" or "Name?" if at least one of them has "Name?"
I assume I would need to combine an IF statement with a lookup function, but I'm not sure how to do this

 

[hiker95]

chatty56,

Try (change the column to suit, or the last row to suit):

=IF(COUNTIF(C2:C65536,"Name?")>0,"Name?",IF(COUNTIF(C2:C65536,"OK")>0,"OK",""))

 

[chatty56]

Thanks hiker95
It worked