Forum Discussion
Tinny426
Sep 06, 2022Copper Contributor
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
- Riny_van_EekelenPlatinum Contributor
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.
- Tinny426Copper ContributorThanks heaps for your help on this, much appreciated.๐
Cheers Richard.