Excel formula help

Steve Brand
Occasional Contributor

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


3 Replies

Hi Steve,


That could be like


Not to worry, did the =MAX formula in A7 and in A6 used an =if formula that happens to work for me.

Thanks, got it as you posted the formula. Thanks a mill.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies