Going to cell with maximum value
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
|