Help with a macroo

Copper Contributor

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

4 Replies

@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)
M13 is fine mate, N13 is picking Cell A15 instead of the L15 value. Please can you help? Kind regards Dave

@harwood66 

my bad

=OFFSET($A$15,0,SUMPRODUCT(COLUMN($L$16:$V$26)*($L$16:$V$26=LARGE($L$16:$V$26,1)))-1)

@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