Home

Excel formula help

Highlighted
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

Steve

3 Replies
Highlighted

Hi Steve,

 

That could be like

image.png

Highlighted

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

Highlighted
Thanks, got it as you posted the formula. Thanks a mill.
Related Conversations
Excel or Access? basic advice from which to start from.
grifton in Excel on
1 Replies
Goal seek
Abui_2195 in Excel on
0 Replies
Preparing a stacked chart
EuroSree in Excel on
2 Replies
Please Help debug my matrix formula
Katharina_Stemmer1989 in Excel on
0 Replies
Linking external source (eg Share Price) to a cell
Aitch1964 in Excel on
0 Replies
Insert an image in Excel header
mat74 in Excel on
1 Replies