HOW TO S.No BY MATCHING DATE IN ADJACENT ROW

[nagovind]

Hi


I have series of date in one row for e.g (in cells B1, B2, B3, B4)


01/01/2006 | 02/03/2008 | 06/05/2009 | 20/10/2010


In the Row above i have revision no. corresponding to the above dates as ..in cells (A1, A2, A3, A4)


A | B | C | D |


From this tow rows i need to know the last date i.e Maximum date and the corresponding revision ...A or B or C or D


I can find max between the dates by MAX(B1:B4) but how to get the equivalent match corresponding to this max date ?


Any formula ? please

 

[oldchippy]

Hi nagovind,


Try this


=INDEX(A1:D1,MATCH(MAX(A2:D2),A2:D2,0))

 

[Hui]

Nagovind,

I think it should be:

=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0))