Jul 06 2020 09:40 AM
Attached is a table that highlights the highest value as red that I want to be able to automate.
Basically if the red highlight is as shown (Yellow axis) I want M13 to show "1" and (Blue Axis) N13 to display "1". Can anyone please help with this? Kind regards Dave
Jul 06 2020 10:16 AM
@harwood66 Try this:
M13:
=OFFSET($K$1,SUMPRODUCT(ROW($L$16:$V$26)*($L$16:$V$26=LARGE($L$16:$V$26,1)))-1,0)
N13:
=OFFSET($A$15,SUMPRODUCT(COLUMN($L$16:$V$26)*($L$16:$V$26=LARGE($L$16:$V$26,1)))-1,0)
Jul 06 2020 02:07 PM
Jul 06 2020 02:47 PM
my bad
=OFFSET($A$15,0,SUMPRODUCT(COLUMN($L$16:$V$26)*($L$16:$V$26=LARGE($L$16:$V$26,1)))-1)
Jul 06 2020 03:36 PM
@mtarler Thanks ever so much for your time and trouble. I am so grateful, amazing. This will save me hour ever week. Kind regards Dave