I would like to tabulate how many times a company is listed in a certain
column as well as have it list all the different ways the various companies
are listed in that column. Is the Pivot table the right tool to use?
Example, I have a list of companies, with many dupes, in column B (because
the names of the customers are in column A). I'm trying to determine all the
unique companies that purchased and if multiple employees from the same
company bought I would like to know the total from that company.
Thanks for your help!!!
Bookmarks