Formula returns Fx, I want Ax

Topic

New Reply

A = Dates
F = numbers
Formula = Max(F:F)
I want to return the corresponding “A” or date of the max number.

EX)
A1= 1/1/2014 F1= 10
A2= 1/7/2014 F2= 50
A3= 1/20/2014 F3= 16

Max(F:F) = 50 [F2]
I want 1/7/2014 [A2]

Reply | Quote

Replies

SkiPro,

How about: [noparse]=INDEX(A1:A3,MATCH(MAX(F1:F3),F1:F3,0),1)[/noparse]
37742-excefx
HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

RG,
Just what I needed but could not quite get correct. Thanks.

Reply | Quote