find maximum and minum variables for multiple names

  • Thread starter Thread starter hamad.fatima
  • Start date Start date
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
 
From your list in col A. Array enter using ctrl+shift+enter
=MAX(IF($b$2:$b$22=A2,$c$2:$c$22))
 
Back
Top