Try Data Pivot Table Multiple Consolidation Ranges with the
options:

- Select to create 0 page fields as these are not needed.
- Select an extra row and column in the range i.e. B2:V344.

(the contents of the extra row/column are not important - can just be
blank).
Click finish and drag row/column out of table and drag Value to the
column position:

Count of Value
Value Total
a 2
c 3
d 1
h 1
v 1
w 1
Grand Total 9

This can be refreshed whenever the data changes.


On May 16, 6:19 pm, carl wrote:
I have a table in C3:V344. Is there a way to create a list of unique values
in the table. For example if my table was like this:

a d w
c v a
c h c

I would like to create a list like this:

a
c
d
h
v
w

Thank you in advance.