asked on 12/27/2017

Find Max value and display adjacent cell contents

Hi,
I would like a formula to find max value and display adjacent cell contents
example
Date Value
20170230 20
20170417 50
20180323 15
20180930 25

max value 50 display 20170417

Many thanks and wish you all a Happy New Year

Ian

Microsoft Office Microsoft Excel Microsoft Applications Spreadsheets

Last Comment

Ian Bell

12/27/2017

Shums Faruk

12/27/2017

Hi Ian,

Assuming your Date Column is in Col A, Values are in Col B and you want result in Col C, try below Formula:

=IF(MAX($B$2:$B$5)=$B2,MAX($B$2:$B$5),"")

Open in new window

Check in attached...
Change the range accordingly
RacePro_MaxValues.xlsx

Ian Bell

12/27/2017

ASKER

Hi Shums,

I was wanting the date actually and place result at top of sheet.
I can find the Max value but would like to know what the date is.
Pls see attached
Thanks
RacePro_MaxValues-V2.xlsx

ASKER CERTIFIED SOLUTION

Shums Faruk

12/27/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Ian Bell

12/27/2017

ASKER

I just had to reverse the ranges to find the date.
Works perfectly
Thanks Shums and have a productive and healthy New Year
Ian