I created a cell that returns the largest value in a row:
=MAX(I41,I80,I117,I155,I193,I230,I270)
I want to reference the date of the highest value which would be in colum A same row numbers:
A41,A80,A117,A155,A193,A230,A270
So if "I155" was the highest then I want a cell that references A155
Any help?
Bookmarks