To anyone reading this, i need to find the MAX value of Column B and display it in C1 including the corresponding date from Column A. In the attached sample sheet, C1 should display "$8,442 on 03-Jul-18". I tried to use INDEX and MAX, but I am only able to display the Max amount and I don't know how to include the date or if this is even possible. thanks!
Bookmarks