| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Data by multiple criteria
I need help understanding a way to sort through a list of records such as the
following: ID Date Updated Notes/History 200G 02/05/2005 Client considering quote 200G 03/04/2005 Client received quote 200E 14/04/2005 Awaiting Board Approval 200E 23/04/2005 Manager not available to discuss 200E 03/02/2005 Client received quote 2001 03/04/2005 Client received quote What I need is to be able to hide or filter out the oldest records to be left with only the most recent activity for each ID. In the example above, I would only want to show the records as follows: ID Date Updated Notes/History 200G 02/05/2005 Client considering quote 200E 23/04/2005 Manager not available to discuss 2001 03/04/2005 Client received quote (Note: Dates above are DD/MM/YYYY) -- Many Tahnks EGGcel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Data by multiple criteria
Add this formula to D2
=B2=MAX(IF($A$2:$A$200=A2,$B$2:$B$200)) as an array formula, so commit with Ctrl-Shift-Enter, and then copy down Then just filter column D for TRUE values -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Eggtavius" wrote in message ... I need help understanding a way to sort through a list of records such as the following: ID Date Updated Notes/History 200G 02/05/2005 Client considering quote 200G 03/04/2005 Client received quote 200E 14/04/2005 Awaiting Board Approval 200E 23/04/2005 Manager not available to discuss 200E 03/02/2005 Client received quote 2001 03/04/2005 Client received quote What I need is to be able to hide or filter out the oldest records to be left with only the most recent activity for each ID. In the example above, I would only want to show the records as follows: ID Date Updated Notes/History 200G 02/05/2005 Client considering quote 200E 23/04/2005 Manager not available to discuss 2001 03/04/2005 Client received quote (Note: Dates above are DD/MM/YYYY) -- Many Tahnks EGGcel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Data by multiple criteria
Excellent - thanks Bob
Many Thanks EGGcel "Bob Phillips" wrote: Add this formula to D2 =B2=MAX(IF($A$2:$A$200=A2,$B$2:$B$200)) as an array formula, so commit with Ctrl-Shift-Enter, and then copy down Then just filter column D for TRUE values -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Eggtavius" wrote in message ... I need help understanding a way to sort through a list of records such as the following: ID Date Updated Notes/History 200G 02/05/2005 Client considering quote 200G 03/04/2005 Client received quote 200E 14/04/2005 Awaiting Board Approval 200E 23/04/2005 Manager not available to discuss 200E 03/02/2005 Client received quote 2001 03/04/2005 Client received quote What I need is to be able to hide or filter out the oldest records to be left with only the most recent activity for each ID. In the example above, I would only want to show the records as follows: ID Date Updated Notes/History 200G 02/05/2005 Client considering quote 200E 23/04/2005 Manager not available to discuss 2001 03/04/2005 Client received quote (Note: Dates above are DD/MM/YYYY) -- Many Tahnks EGGcel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Combining Data multiple tabs | Excel Discussion (Misc queries) | |||
| Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
