How to enter a value for the first row based on the earliest date?
Here is how the file is structured:
Column A has multiple duplicate entries because this file shows all the orders we have and some companies order multiple times while some order just once.
We want to label their first order (based on Column C's Job Accepted) in Column E as "First".
first value.png
Here is the end result of I'm looking to achieve
first value 2.png
The goal behind this:
We want to calculate how much a client is worth based on their first order.
Example, for all clients who first ordered Stickers how much are they worth vs clients who ordered Flags first.
Bookmarks