I have a worksheet containing incoming and outgoing payments, over a reasonable time period. Each item contains a date, a store name, and the amount.
I want to create a summary worksheet, where first column is "store name", for example. At present I create the list of stores manually and do the conditional lookups, sums, averages, etc.. based on this first column. However, I can never be sure if I've missed anything, and the list of stores changes from time to time.
How do I get a list of unique store names from this list of duplicated store names? In short, how do I create the first column?
Thanks!
I want to create a summary worksheet, where first column is "store name", for example. At present I create the list of stores manually and do the conditional lookups, sums, averages, etc.. based on this first column. However, I can never be sure if I've missed anything, and the list of stores changes from time to time.
How do I get a list of unique store names from this list of duplicated store names? In short, how do I create the first column?
Thanks!