OK, maybe there's a better way to do this, but I have the Colorindex function
(from Ozgrid, I think) and I want to get the maximum value over a number of
cells:

I have something like this:

=MAX(colorindex(A1),colorindex(A2),colorindex(A3))

I want to go 10 columns. Is there an easier way to do this? I know I can
write another macro, but I don't really want to do that right now.

Thanks,
Barb Reinhardt

Without knowing how the colorindex function works makes it rather
difficult to answer that. To make the formulas easier for you, it might
be easier to create a dummy row. Although, I hate to recommend that.
Unfortunatly it's the best I can do. The dummy row B where the formula
would be =colorindex(a1)... etc. and then do the max on Row B.


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=543340

Barb Reinhardt wrote:
OK, maybe there's a better way to do this, but I have the Colorindex function
(from Ozgrid, I think) and I want to get the maximum value over a number of
cells[.] I have something like this:
=MAX(colorindex(A1),colorindex(A2),colorindex(A3))
I want to go 10 columns. Is there an easier way to do this?

I cannot say it is "easier", but it might be more extensible. In B1,
put =colorindex(A1) and copy into A2:A10. Then you can write
=max(A1:A10).

If you do not like column B1 cluttering up your spreadsheet, you
can hide the column.

Barb,

Grab my Colorindex function from
http://www.xldynamic.com/source/xld.ColourCounter.html and use
=MAX(ColorIndex(A1:A10))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Barb Reinhardt" wrote in message
...
OK, maybe there's a better way to do this, but I have the Colorindex
function
(from Ozgrid, I think) and I want to get the maximum value over a number
of
cells:

I have something like this:

=MAX(colorindex(A1),colorindex(A2),colorindex(A3))

I want to go 10 columns. Is there an easier way to do this? I know I can
write another macro, but I don't really want to do that right now.

Thanks,
Barb Reinhardt

I did that, but it means adding 20 more columns and I don't really want to do
that. For now, it works. In the future, I'll look at modifying the macro.

Thanks

"kraljb" wrote:


Without knowing how the colorindex function works makes it rather
difficult to answer that. To make the formulas easier for you, it might
be easier to create a dummy row. Although, I hate to recommend that.
Unfortunatly it's the best I can do. The dummy row B where the formula
would be =colorindex(a1)... etc. and then do the max on Row B.


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=543340