Need to catch highest value plus data on same row.

Occasional Contributor

Hi all,

This is probably simple for most.....

I have a column of numbers and i know the formula to get the highest value, but i also want

the data from a different column on that row that has the highest value.

Hopefully you can understand below.

 

 

Screenshot 2022-09-06 143006.png 

2 Replies

@Tinny426 Rather than just providing a bunch of formulas in text, please find a working example, based on your screen shot, in the attached file.

Thanks heaps for your help on this, much appreciated.
Cheers Richard.