find maximum and minum variables for multiple names

H

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
 
D

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))
 
Top