Find the Max date for an item that is listed multiple times

[gheyman]

I have a list of parts all listed down a row (A). Then I have a date column that shows the last time I purchased that part. The parts are listed multiple times in the list and the last purchase date isn't going to be towards the top of the list.

I cant sort the data for various reasons. Is there a type of lookup formula that finds the max date?

 

[RasGhul]

Hi,

Book1
	A	B
1	Parts
2	Part1	01-01-19
3	Part2	02-01-19
4	Part3	03-01-19
5	Part1	04-02-19
6	Part5	05-02-19
7	Part6	06-01-19
8	Part1	07-04-19
9	Part8	08-01-19
10	Part1	09-10-19
11	Part10	10-01-19
12
13	Part1	09-10-19
Sheet1

Cell Formulas
Range	Formula
B13	{=MAX(IF($A$2:$A$11=$A$13,$B$2:$B$11))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[gheyman]

Thank You. That worked!