3 Nov 2014 at 10:21 #1 LupoLover LupoLover Associate Joined 15 Jul 2008 Posts 1,225 I know cheeky to ask but well if you dont ask I got a Column full of FALSE in most instances, sometimes a few might say TRUE, how do I create a box that says: If any cell in Column A shows a TRUE then this Cell shows "YES". Cheers Sheldon
I know cheeky to ask but well if you dont ask I got a Column full of FALSE in most instances, sometimes a few might say TRUE, how do I create a box that says: If any cell in Column A shows a TRUE then this Cell shows "YES". Cheers Sheldon
3 Nov 2014 at 10:29 #2 GravyMonster GravyMonster Soldato Joined 18 Oct 2002 Posts 15,409 Location The land of milk & beans You can use COUNTIF, something like this: =IF(COUNTIF(A1:A99999, "=TRUE") > 0, "YES", "NO")
