M
Mike
Hello All,
Using Excel XP
I want to find the three highest times (COLUMN A and COLUMN D) and have the
corresponding Month/Year (COLUMN B and COLUMN E) match.
For example the 3 highest times and Month/Year would be:
1. 25:24:22 Jan 2004
2. 22:49:48 Jan 2003
3. 16:44:42 Jul 2004
Here's is a formula that I have, but it returns #N/A
=INDEX($B$1:$B$4,$E$1:$E$4,MATCH(LARGE(($A$1:$A$4,$D$1:$D$4),1),($A$1:$A$4,$
D$1:$D$4),0))
A B C D E
1 25:24:22 Jan 2004 16:44:42 Jul 2004
2 22:49:48 Jan 2003 15:37:23 Jul 2003
3 13:00:37 Jan 2002 13:22:08 Jul 2001
4 12:57:39 Jan 2001 11:16:22 Jul 2000
Any help would be appreciated in getting the formula to work correctly.
Thank you,
Michael
Using Excel XP
I want to find the three highest times (COLUMN A and COLUMN D) and have the
corresponding Month/Year (COLUMN B and COLUMN E) match.
For example the 3 highest times and Month/Year would be:
1. 25:24:22 Jan 2004
2. 22:49:48 Jan 2003
3. 16:44:42 Jul 2004
Here's is a formula that I have, but it returns #N/A
=INDEX($B$1:$B$4,$E$1:$E$4,MATCH(LARGE(($A$1:$A$4,$D$1:$D$4),1),($A$1:$A$4,$
D$1:$D$4),0))
A B C D E
1 25:24:22 Jan 2004 16:44:42 Jul 2004
2 22:49:48 Jan 2003 15:37:23 Jul 2003
3 13:00:37 Jan 2002 13:22:08 Jul 2001
4 12:57:39 Jan 2001 11:16:22 Jul 2000
Any help would be appreciated in getting the formula to work correctly.
Thank you,
Michael