Mar 13 2019 04:21 AM
Hi All,
A1 = Name
A2 = Value
A3 = Value
A4 = Name
The highest value must pull through to A7 and the name linked to that value must pull through to A6
Thus if A1 = John, A2 = 10, A3 = 17, A4 = Steve then A7 = 17 and A6 = Steve.
Would anyone know how to assist with this formula?
Thank you
Kind Regards
Steve
Mar 13 2019 05:51 AM
Not to worry, did the =MAX formula in A7 and in A6 used an =if formula that happens to work for me.
Mar 13 2019 05:52 AM