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: Imgur: The most awesome images on the Internet

Example explained:

All orders listed are from xyzindustries@.com

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!

 

[Logit]

.

the goal is to filter all rows but those that appear on date 1/27/2017

Highlight A1 : C1

Click on the DATA tab up top

Click on the FILTER icon (looks like a funnel)

Small grey boxes now appear in A1 : C1

In B1, click the grey box.

Uncheck (SELECT ALL)

Now click on the date 1/27/2017


You can do the same for any other date and also filter down by using the other columns as well.


Now if by "filtering" you meant "Delete" all rows but those containing 1/27/2017 .... then that's another approach.