How to display the maximum date value from a range?

Question

Google Sheets

There is a column with "Name" and a column "Date and time of registration". How to display the date and time of the last registration for each full name?

Answer 1

=МАКС(FILTER($B:$B;$A:$A=$A$2))
$A:$A = Full name
$B:$B = Date
Or you can do this:

=QUERY(QUERY(A:B;"SELECT A,MAX(B) WHERE A IS NOT NULL GROUP BY A";0);"SELECT * OFFSET 1";0)

Demo table