Forum Discussion
Finding Location of Maximum Value
I have two tabs in my worksheet MeterData and PeakLoad I am trying to locate the maximum value from an array in MeterData tab, cells F2:CW733. I also need to find the date corresponding to the maxim...
KiranPK The problem is that match is for a 1-d array and you are giving it a 2-d array. I would suggest you use a helper column to find the max value on the row and then you can find the max row in the helper column and the max in the row to find your max cell but it would be cleaner if you also have a helper row to find which column has the max value.