My actual problem has about 10
different ranges to search and I need to
perform 27 different instances of this.
Then why didn't you "say" that in the first place? <g
There is no elegant way to do this! You're going to end up with a long ugly
formula. The OR function can have up to 30 arguments so you're well within
that limit with just 10.
Biff
"solinar" wrote in
message ...
Hi:
Thanks for the response, but I tried the countif function because using
if and or functions were too cumbersome. My actual problem has about 10
different ranges to search and I need to perform 27 different instances
of this.
I was hoping to find something easier than typing a logic statement for
each of the 10 ranges (and then modifying that for each of the 27
instances I have to do it in).
Thanks anyway for the reply though.
--
solinar
------------------------------------------------------------------------
solinar's Profile:
http://www.excelforum.com/member.php...o&userid=31159
View this thread: http://www.excelforum.com/showthread...hreadid=508216