Excel: Help with Match Index and MAX Formula

1 01/05/17 Apple
2 02/05/17 Orange
3 01/06/17 Apple
Hello. I have spent quite some time making a formula to display the date for the latest sale of some of my products. I have another topic about this but those formulas did not work, i believe because the max function only operates if you are using numbers? (it says on the microsoft support site [I]"If the arguments contain no numbers, MAX returns 0 (zero).") [/I] Column A is actually a formula giving them date as it is a vlookup function. Maybe that is why i have been failing making this formula??

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of May 08, 2017.

For more resources for Microsoft Excel