find maximum and minum variables for multiple names
 

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

find maximum and minum variables for multiple names
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
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