M
Mike
Hello All,
Using Excel XP.
I have two worksheets, one named "TIMES" and the other "HI&LO". On sheet
"TIMES" I have a month & year in column A and a time in column B, e.g:
A B
----------------------------------
1 March 04 15:45
2 April 04 13:22
3 May 04 18:01
4 June 04 15:38
On Sheet "HI&LO" I have in column A the two Highest Times from sheet
"TIMES", e.g:
A
B
----------------------------------------------------------------------------
-----
1 =LARGE(TIMES!$B1:$B4,1) gives the value of 18:01
2 =LARGE(TIMES!$B1:$B4,2) gives the value of 15:45
How can I get the value of B1 to equal May 04 and B2 to equal March04. I
know it's an index and match formula but I can't get it to work.
Thanks in advance for any help in this matter.
Michael
Using Excel XP.
I have two worksheets, one named "TIMES" and the other "HI&LO". On sheet
"TIMES" I have a month & year in column A and a time in column B, e.g:
A B
----------------------------------
1 March 04 15:45
2 April 04 13:22
3 May 04 18:01
4 June 04 15:38
On Sheet "HI&LO" I have in column A the two Highest Times from sheet
"TIMES", e.g:
A
B
----------------------------------------------------------------------------
-----
1 =LARGE(TIMES!$B1:$B4,1) gives the value of 18:01
2 =LARGE(TIMES!$B1:$B4,2) gives the value of 15:45
How can I get the value of B1 to equal May 04 and B2 to equal March04. I
know it's an index and match formula but I can't get it to work.
Thanks in advance for any help in this matter.
Michael