Forum Discussion

bertie395's avatar
bertie395
Copper Contributor
Oct 25, 2022

Max and adjacent data in column

I have a number of rows and am returning the maximum number in a specific row. eg (MAX(A1:A20)). I also wish to return the data from another row that corresponds to the cell where the maximum number ...

Resources