I have 300 customers and for each order an indicator of how it was placed,
i.e telephone, email or website. There have been approx 1500 orders placed to
date from these 300 customers. Some customers order by a different method
each time. I need to know who orders but phone only, who orders by email
only, who orders by website only and who orders by a mixture of these
methods. I have a list of all orders where column A = customer name and
column B = order method. I am using excel 2007