Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find cell contains the result of "maximum" formula
-- De |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find cell contains the result of "maximum" formula
If I understood you right, do a CTRL+F and type what you're looking for (is
it "MAX" ?). Click the Options button, and set it to search in formulas, and not values. "De" wrote: -- De |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find cell contains the result of "maximum" formula
Thanks, Raffael, but I wondered if there was a conditional format etc that
might do it as I have 200 rows and 58 columns of data. I have entered a "max" formula for each row and need to know which cell in each row contains the "max" result. -- De "De" wrote: -- De |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find cell contains the result of "maximum" formula
You can use conditional formatting for this.
Select your entire range of data From the Format Menu, choose "Conditional Formatting..." Set Cell Value "Equal to" and type in: =MAX($A1:$BF1) Set your format (red background maybe?) Click OK Change the above formula to match your actual range of data. The Maximum value(s) in each row should now be highlighted. HTH, Elkar "De" wrote: Thanks, Raffael, but I wondered if there was a conditional format etc that might do it as I have 200 rows and 58 columns of data. I have entered a "max" formula for each row and need to know which cell in each row contains the "max" result. -- De "De" wrote: -- De |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find cell contains the result of "maximum" formula
Ok, in that case you're right and may use the "conditional formatting". I
have some personal spreadsheets that use this kind of logic. So, you should select "Formula is" in the conditional formatting box, type something as "=MAX($A1:$BZ1)" and select the formatting that you want to highlight the cell with the max value in that row. One way you can do that is selecting the entire matrix, making sure that the line in the formula would be the same as the one in the formula. You must block the columns, but not the rows. Regards "De" wrote: Thanks, Raffael, but I wondered if there was a conditional format etc that might do it as I have 200 rows and 58 columns of data. I have entered a "max" formula for each row and need to know which cell in each row contains the "max" result. -- De "De" wrote: -- De |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find cell contains the result of "maximum" formula
Thank you Elkar. I just tried it and it works perfectly. Thanks, again.
-- De "Elkar" wrote: You can use conditional formatting for this. Select your entire range of data From the Format Menu, choose "Conditional Formatting..." Set Cell Value "Equal to" and type in: =MAX($A1:$BF1) Set your format (red background maybe?) Click OK Change the above formula to match your actual range of data. The Maximum value(s) in each row should now be highlighted. HTH, Elkar "De" wrote: Thanks, Raffael, but I wondered if there was a conditional format etc that might do it as I have 200 rows and 58 columns of data. I have entered a "max" formula for each row and need to know which cell in each row contains the "max" result. -- De "De" wrote: -- De |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find cell contains the result of "maximum" formula
Thank you, Raffael. I found that worked if I "cell is" in the conditional
formatting box. Many thanks, -- De "Raffael" wrote: Ok, in that case you're right and may use the "conditional formatting". I have some personal spreadsheets that use this kind of logic. So, you should select "Formula is" in the conditional formatting box, type something as "=MAX($A1:$BZ1)" and select the formatting that you want to highlight the cell with the max value in that row. One way you can do that is selecting the entire matrix, making sure that the line in the formula would be the same as the one in the formula. You must block the columns, but not the rows. Regards "De" wrote: Thanks, Raffael, but I wondered if there was a conditional format etc that might do it as I have 200 rows and 58 columns of data. I have entered a "max" formula for each row and need to know which cell in each row contains the "max" result. -- De "De" wrote: -- De |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency to Text | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) |