Latest date

[Tofik]

Hi guys, how are you? Guys, I need to understand which formula can show me the latest date in my product list?

On the left side is my imagination example Data Base and on the right the final version of how it should be.
I need to solve problems as fast as possible because I should give the report the final version to my boss.
Thanks, guys.

AF-099-QF-199 Welding Log FINAL VERSION.xlsb
	D	E	F	G	H	I
6	product name	date			product name	last date
7	apple	01.01.2021			apple	02.01.2021
8	apple	02.01.2021			banana	01.01.2021
9	banana	01.01.2021			cherry	07.01.2021
10	orange	03.01.2021			orange	08.01.2021
11	cherry	07.01.2021
12	apple
13	orange
14	orange
15	orange	08.01.2021
16
17
Sheet1

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	product name	date			product name	last date
2	apple	01/01/2021			apple	02/01/2021
3	apple	02/01/2021			banana	01/01/2021
4	banana	01/01/2021			orange	08/01/2021
5	orange	03/01/2021			cherry	07/01/2021
6	cherry	07/01/2021
7	apple
8	orange
9	orange
10	orange	08/01/2021
11
Test

Cell Formulas
Range	Formula
E2:E5	E2	=UNIQUE(FILTER(A2:A100,A2:A100<>""))
F2:F5	F2	=MAXIFS(B:B,A:A,E2#)
Dynamic array formulas.

 

[RoryA]

Or use a pivot table and the Max function for the date.

 

[alansidman]

With Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Trimmed Text" = Table.TransformColumns(Source,{{"product name", Text.Trim, type text}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Trimmed Text",{{"product name", type text}, {"date", type datetime}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"product name"}, {{"Max Date", each List.Max([date]), type nullable datetime}})
in
    #"Grouped Rows"