Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a function or macro to select cells with the ten highest values
in selected rows over 25 worksheets. I am not looking the maximum of each sheet. It is possible all ten could be in one sheet. I have a feeling the code would need to loop through all 2024 numbers, placing them in an array and sorting from maximum to minimum - grab the ten with the highest value then activate the cells with the maximums so that they can all changed to a set value. Any suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maximum value in a cell | Excel Discussion (Misc queries) | |||
Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
maximum value of a cell | Excel Discussion (Misc queries) | |||
Maximum value of a cell | Excel Discussion (Misc queries) | |||
Maximum Value in a Cell | Excel Discussion (Misc queries) |