Thread: [Solved] If formula
View Single Post
 
Old 10-02-2009, 08:02 AM
CGM3 CGM3 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

Code:
=IF(COUNTIF(sheet1!A1:IV65536,"x")>0,True,False)
That's using 65,536 as the maximum number of rows a worksheet can have, and 256 as the maximum number of columns. If you don't expect that much of sheet1 to be used, you can use lower values.

In fact, you can select the region of sheet1 you need to check, name it (Insert | Name | Define) and use that name in the formula, redefining the area it covers as necessary:
Code:
=IF(COUNTIF(LookForX,"x")>0,True,False)
Of course, this only works if "x" is the only character in a cell.

Last edited by CGM3; 10-02-2009 at 10:29 AM.
Reply With Quote