Max of a defined function
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 |
Max of a defined function
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 |
Max of a defined function
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. |
Max of a defined function
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 |
Max of a defined function
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 |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com