I would like to find the values and count duplicates on a sheet. Here is my example:

[TABLE="width: 500"]

A1

[/td]A2

[/td]**Organization1**

**Organization2**

XXY

[/td]BBA

[/td]ACC

[/td]XXY

[/td]BBA

[/td]ABC

[/td]

[/TABLE]

I would do countif, but I do not know my values (this is from a report that I ran from a database) and it would take too long to find all the individual values every time I needed to run this report. So this is what I am looking for (a graph would work too).

[TABLE="width: 500"]

A3

[/td]A4

[/td]ABC

[/td]1

[/td]ACC

[/td]1

[/td]BBA

[/td]2

[/td]XXY

[/td]2

[/td]

[/TABLE]

Thanks in advance!