Issue trying to filter out spreadsheet, need help

[Zenfoldor]

I have a list of line items. Each one lists a type of product that was included in a customers order.

In the list, column A is the order number. Several line items will share an order number.

In column B I list the date the order was created.

In column C I list the email of the person who placed the order.

I want to remove any rows that don't have the original date the customer ordered.

Right now my report is showing line items for every order the customer has ever created, and I only want to show line items from the customer's first order. Keep in mind, each order has multiple line items.

Example: http://imgur.com/Wfpm7cK

Example explained:

All orders listed are from [email protected]

I want to eliminate all rows that were not from the customers original order. In this example, the customers original order is one 1/27/2017.

In the attached example, the goal is to filter all rows but those that appear on date 1/27/2017, while leaving ALL rows visible that do appear on that date.

Thanks!

[JLGWhiz]

1. Select the range of data you want to filter.
2. On the ribbon, select Data, then click the Funnel icon to turn on filters.
3. In the column with customers, click the down arrow in the first filter row.
4. Uncheck all but the one you want to filter on.and click OK
5. In the column with order numbers, click the down arrow in the first filter row.
6. Uncheck all but the one you want to filter on and click OK
7. In the column with the dates, click the down arrow in the first filter row
8. Uncheck all but the one you want to filter on and click OK.
you should now have a filtered list of only items on the original order.