Hi, I have alternating columns of Date 1, Amount 1, Date 2, Amount 2, etc. corresponding to a record in column A. I have this setup as Date 1 (H6), Amount 1 (I6), Date 2 (J6), Amount 2 (K6) etc.
I want to be able to see the most recent date and the corresponding figure from that date.
So far I have =MAX(H6,J6,L6,N6,P6) to show the most recent date, but I need another formula to show the value from the adjacent cell to the one returned in the MAX formula.
Any ideas?
Thanks!
I want to be able to see the most recent date and the corresponding figure from that date.
So far I have =MAX(H6,J6,L6,N6,P6) to show the most recent date, but I need another formula to show the value from the adjacent cell to the one returned in the MAX formula.
Any ideas?
Thanks!