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!
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!
