Hi
I need to work out the number of unique times a customer purchases by month/year and what type of business it is.
Basically it is either New or Renewal business and the unique reference is the order number, however I have multiple lines per order but only want to count the whole order once. I have attached a spread sheet that should hopefully make more sense.
Unique Orders.xlsx
thanks
Bookmarks