filter

[Guest]

I have a data which in a single column. I want the data to be filtered with only the following details
For return ID 123456, the total cost was 51.20.
Total units returned: 1
TUL 11-JAN-0

Return ID Dist. ASIN Qty Reason Cost Whse. Subtotal Process Date

123456 abcdef 789654321 1 V 51.20 TUL 11-JAN-02

For return ID 123456, the total cost was 51.20.
Total units returned: 1


7890123 abcdef 1567204104 1 O 55.96 TUL1 23-JAN-02
7890123 abcdef 0868632686 9 O 126.00 TUL1 23-JAN-02
7890123 abcdef 086863252X 5 O 70.00 TUL1 23-JAN-02
7890123 abcdef 0435088092 5 O 140.00 TUL1 23-JAN-02
7890123 abcdef 0435072277 4 O 59.20 TUL1 23-JAN-02
7890123 abcdef 0325001146 1 O 13.56 TUL1 23-JAN-02
7890123 abcdef 0275938476 1 O 16.76 TUL1 23-JAN-02
7890123 abcdef 0313318298 1 O 49.60 TUL1 23-JAN-02
7890123 abcdef 0325003505 1 O 22.40 TUL1 23-JAN-02
7890123 abcdef 0435087622 2 O 35.20 TUL1 23-JAN-0
7890123 abcdef 0435088092 2 O 56.00 TUL1 23-JAN-0
7890123 abcdef 086863252X 2 O 28.00 TUL1 23-JAN-0
7890123 abcdef 086863252X 4 O 56.00 TUL1 23-JAN-0

For return ID 7890123, the total cost was 728.68
Total units returned: 3

 

[Debra Dalgleish]

Select the column, and choose Data>Filter>AutoFilter
From the dropdown list in the heading cell, choose Custom
In the first dropdown, choose 'Begins with'
In the text box, type: For
Click OK