find maximum and minum variables for multiple names

[hamad.fatima]

HI,
I have a file with names of the students for several years. Each
studne thas multiple start and end dates. I want to create a macro
which will only create the list of the names ( appearing onece) and
just the first start dates and the ;atest end dates for the students.

thanks

 

[Don Guillett]

From your list in col A. Array enter using ctrl+shift+enter
=MAX(IF($b$2:$b$22=A2,$c$2:$c$22))