unique list from list of duplicates

[darmis]

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!

 

[T. Valko]

That worked like a charm. I thank you again.

lol I especially like you referring to it as "that thing". Is it typically problematic?

It's an old tool that probably worked pretty well when it was first created. It hasn't been updated to work with newer ("modern") browsers and updated forum software.

I like using this add-in to post sample data:

http://www.excel-jeanie-html.de/index.php?f=1

 

[michell feitosa]

Mr Excel you are a genius!! I've been looking for a solution like that for ages!! Thanks God a joined Mr Excel.com

 

[Aladin Akyurek]

Mr Excel you are a genius!! I've been looking for a solution like that for ages!! Thanks God a joined Mr Excel.com

You probably refer to post #5...

We can re-write the formula in F3 as follows to make the fast formula system more so:

F3, copied doen:

F3, copied down:
=IF(ROWS(F$3:F3)<=$F$1,INDEX($A$3:$A$9,MATCH(ROWS(F$3:F3),$D$3:$D$9)),"")