I am looking for a function to search through multiple ranges of cells
and return a number if it finds any instances of that number.

For instance:
I have say 6 cells, (A1, C17, F13:G14) and I want to find out if any of
them contain the number "1" and if they do, I want the result of B2 to
be "1".

The way I thought I could accomplish this was to go to cell B2 and do
the formula =if(countif((A1,C17,F13:G14),"1")0,1,0)

This seems to work for a single range such as
=if(countif(F13:G14,"1")0,1,0)

I just dont know the proper syntax for including multiple ranges in a
function.

If anyone knows how to include multiple ranges in a function (if its
possible), or knows a simpler way to do what I am trying to do, the
help would be greatly appreciated.


--
solinar
------------------------------------------------------------------------
solinar's Profile: http://www.excelforum.com/member.php...o&userid=31159
View this thread: http://www.excelforum.com/showthread...hreadid=508216