Forum Discussion

Tinny426's avatar
Tinny426
Copper Contributor
Sep 06, 2022

Need to catch highest value plus data on same row.

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.

 

 

 

2 Replies

    • Tinny426's avatar
      Tinny426
      Copper Contributor
      Thanks heaps for your help on this, much appreciated.๐Ÿ‘
      Cheers Richard.

Resources