If I have on my spread sheet the following :-


(D-1) 20
(D-2) 50
(D-3) 10

(E-1) 5/1/2015
(E-2) 6/4/2015
(E-3) 7/5/2014





The "D" cells are just a number and the "E" cells are the date when that
number occurred

In A-1 I have =MAX(D1:D100) to find the maximum number for the 100 D cells,
but what I want is in the B-1 cell the date where the maximum was found and
I do not know the formula.

The answer should be, if I have that formula :-

A1 cell would be 50
B1 cell would be 6/4/2015

Can anyone help?


---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com