I'm trying to do some conditional formatting to find the first order of a customer. Our information is the order date and the customer number. We have more information than that available, but don't feel like generating it or exposing our customers.
Right now I have =OR(AND($B2=$B3,$A2=$A3)) but it's incomplete and nonfunctional. It never highlights the last order either since the last order's orderdate doesn't match the next. It should be highlighted though. Can't figure out how to do that.
What we're trying to find out is what returning customers bought in their first order that caused them to return to our website to buy more. Trying to find whether or not new customers get more advertisement than returning customers amongst other metrics we could measure with this information.
Any ideas?
Bookmarks