|
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 |
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 |
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 |
| All times are GMT +1. The time now is 04:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com