software

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: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=543340Barb Reinhardt wrote:
gt; OK, maybe there's a better way to do this, but I have the Colorindex function
gt; (from Ozgrid, I think) and I want to get the maximum value over a number of
gt; cells[.] I have something like this:
gt; =MAX(colorindex(A1),colorindex(A2),colorindex(A3))
gt; I want to go 10 columns. Is there an easier way to do this?

I cannot say it is quot;easierquot;, 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
www.xldynamic.com/source/xld.ColourCounter.html and use
=MAX(ColorIndex(A1:A10))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Barb Reinhardtquot; gt; wrote in message
news
gt; OK, maybe there's a better way to do this, but I have the Colorindex
function
gt; (from Ozgrid, I think) and I want to get the maximum value over a number
of
gt; cells:
gt;
gt; I have something like this:
gt;
gt; =MAX(colorindex(A1),colorindex(A2),colorindex(A3))
gt;
gt; I want to go 10 columns. Is there an easier way to do this? I know I can
gt; write another macro, but I don't really want to do that right now.
gt;
gt; Thanks,
gt; Barb Reinhardt
gt;
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

quot;kraljbquot; wrote:

gt;
gt; Without knowing how the colorindex function works makes it rather
gt; difficult to answer that. To make the formulas easier for you, it might
gt; be easier to create a dummy row. Although, I hate to recommend that.
gt; Unfortunatly it's the best I can do. The dummy row B where the formula
gt; would be =colorindex(a1)... etc. and then do the max on Row B.
gt;
gt;
gt; --
gt; kraljb
gt; ------------------------------------------------------------------------
gt; kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
gt; View this thread: www.excelforum.com/showthread...hreadid=543340
gt;
gt;