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

Group data and pick a particular row based on a condition
 

What i can do is Sort by ProgramName+programtype+PIR Cycle#(Desc) and then
loop thru all the rows and pick the first occurance. I want to know if there
is any better way of doing this.

Thanks Again

"VishalBade" wrote:

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