View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default How can you use multiple ranges in a function?

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