| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return only 1 record w/ multiple records?
Hello,
Here is what I am trying to achieve. For order with multiple oper, it only returns one order with the lowest oper number. What can I do to achieve this. Thanks Table with the following data: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 5000 8951 1/4/08 ABC 205 6000 8951 1/8/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 result of query data I like to achieve: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 ABC 205 5000 8951 1/4/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 Records that are excluded: AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 6000 8951 1/8/08 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return only 1 record w/ multiple records?
With the sample of data you show........
Select B1:B9 then DataFilterAdvanced Filter. Unique Records only and either filter in place or copy to another location. Returns....... Part Order Oper WC Date AAA 123 1000 8951 1/2/2008 ABC 205 5000 8951 1/4/2008 ABZ 314 1000 8951 1/3/2008 AAH 380 2000 8951 1/3/2008 Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 10:36:02 -0800, Cam wrote: Hello, Here is what I am trying to achieve. For order with multiple oper, it only returns one order with the lowest oper number. What can I do to achieve this. Thanks Table with the following data: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 5000 8951 1/4/08 ABC 205 6000 8951 1/8/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 result of query data I like to achieve: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 ABC 205 5000 8951 1/4/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 Records that are excluded: AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 6000 8951 1/8/08 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return only 1 record w/ multiple records?
Gord,
Thanks for the suggestion. But I need an extra step beyond filtering. The method you shows only filter them, but the rest of the unused data (rows) are hidden. But what I need to achieve is the completely delete those hidden rows after filtering. "Gord Dibben" wrote: With the sample of data you show........ Select B1:B9 then DataFilterAdvanced Filter. Unique Records only and either filter in place or copy to another location. Returns....... Part Order Oper WC Date AAA 123 1000 8951 1/2/2008 ABC 205 5000 8951 1/4/2008 ABZ 314 1000 8951 1/3/2008 AAH 380 2000 8951 1/3/2008 Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 10:36:02 -0800, Cam wrote: Hello, Here is what I am trying to achieve. For order with multiple oper, it only returns one order with the lowest oper number. What can I do to achieve this. Thanks Table with the following data: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 5000 8951 1/4/08 ABC 205 6000 8951 1/8/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 result of query data I like to achieve: Part Order Oper WC Date AAA 123 1000 8951 1/2/08 ABC 205 5000 8951 1/4/08 ABZ 314 1000 8951 1/3/08 AAH 380 2000 8951 1/3/08 Records that are excluded: AAA 123 2000 8951 1/3/08 AAA 123 3000 8951 1/7/08 AAA 123 4000 8951 1/3/08 ABC 205 6000 8951 1/8/08 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to color 1 record of each set of Duplicate Records | Excel Worksheet Functions | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| to make a single row record become multiple row records | Excel Worksheet Functions | |||
| how do I set a record keeping template for church records? | Excel Discussion (Misc queries) | |||
| How to merge records into one record by customer's name? | New Users to Excel | |||
Hybrid Mode
