Group data and pick a particular row based on a condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB code to update existing Pivot Table 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Printing sheets based on a cell value 1
Delete rows based on contents of Col A 0
Highlight Row Based On Condition-So close 3
A Huge Conditional Format Challenge.... 2
Delete Rows with Conditions 1
How do I hide rows based on spedific conditions? (VBA novice) 3

Back
Top