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...
Formula to find max location in 2D range is here https://exceljet.net/formula/get-location-of-value-in-2d-array