Thread: Group data and pick a particular row based on a condition
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VishalBade VishalBade is offline
external usenet poster
  
Posts: 7
Default Group data and pick a particular row based on a condition
Program Name Program Type PIR Cycle#
CE1 Customer Experience 1
CE1 Customer Experience 2
F1 Function 1
PP1 Platform Program 1

I have to group by ProgramName+Program Type and then pick the row with the
max of PIR Cycle# column value

Thanks in advance

Reply With QuoteReply With Quote