G
Guest
I am trying to compile a list of sales by customer and total purchases by
that customer in a series of months. I have column a as a master list of
customer names. Column B is going to be the charges for that customer in
lets say may. Column c is going to be the charges for that customer in June.
The problem I am having is that not all customers have charged from us in
the same months so when I bring my data into this worksheet it contains the
customer name in one column and the charges in another. Doing this does not
allow the customer names for one month to line up with the next month because
there may be fewer customers in a certain month. How can I multiple sort
columns to get the customer names to match the ones in column and leave
blanks where there is not a customer.
Thank you
Jeremy
that customer in a series of months. I have column a as a master list of
customer names. Column B is going to be the charges for that customer in
lets say may. Column c is going to be the charges for that customer in June.
The problem I am having is that not all customers have charged from us in
the same months so when I bring my data into this worksheet it contains the
customer name in one column and the charges in another. Doing this does not
allow the customer names for one month to line up with the next month because
there may be fewer customers in a certain month. How can I multiple sort
columns to get the customer names to match the ones in column and leave
blanks where there is not a customer.
Thank you
Jeremy