Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Query with a twist.... (Cross Posted)
Hi,
I can identify duplicates based on the ID and name as outlined below, However what I need to be able to do is to identify duplicates and delete or tag the row containing the lowest Createdate. This is further compounded by the fact that if a record has the same id, name and createdate then the Outcome field should filter on using the outcome field where the outcome description Sold overides any other. ( See last two rows in exapnle data) ID Name Createdate Outcome 8,431 MOORCROFT RECOVERY Ltd 09/11/2006 Done 24,570 Air Affairs (SA) Ltd 13/11/2006 Sold 25,698 Pickfords Business Moving 01/11/2006 Sold 35,416 Personal Performance Cons 01/11/2006 Done 42,270 National School of Government 09/11/2006 Sold 43,838 National School of Government 09/11/2006 Done 45,299 Fiesta Blinds & Fabrics 13/11/2006 Done 104,635 James Stack & Sons Ltd 14/11/2006 Done 114,084 Anders Elite 12/10/2006 Sold 120,666 Remsdaq Ltd 30/10/2006 Sold 120,723 BANNER BUSINESS 09/11/2006 Undecided 120,723 BANNER BUSINESS 09/11/2006 Sold Thanks for your help :) B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
changing query source | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
How can I cross reference 2 excel docs to look for duplicate info | Excel Worksheet Functions |