Count unique records in a list

[Leon]

I also have a question about unique records in a list.
Is there a way to create a list of unique records in a
column (such as names in column A), and have the list
update in a chart in another worksheet?

Can the chart adjust, based on the number of unique names
(for example, in one month I might have 10 unique names to
display on a chart, the next I might have only 5)?

Thanks,

Leon

 

[Frank Kabel]

Hi
use 'Data - Filter - Advanced Filter' to create a list of unqiue values

 

[Leon]

Thanks, but I was looking for a way to dynamically update
the list. For example, if a new name is added to column
A, then I would like the unique list to automatically
update.

Is this possible?

And thanks for your help!

Leon

 

[Frank Kabel]

Hi
o.k. if your list is in A1:A100 try the following formulas:
B1: = $A$1

B2: =
INDEX($A$1:$A$100,MATCH(0,COUNTIF($B$1:B1,$A$1:$A$100)+70000*ISBLANK($A
$1:$A$100),0))

the formula in B2 is an array formula (has to be committed with
CTRL+SHIFT+eNTER). Copy this formula down as far as needed