Return only 1 record w/ multiple records?

[Cam]

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

 

[Gord Dibben]

With the sample of data you show........

Select B1:B9 then Data>Filter>Advanced 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

 

[Cam]

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.