## Count unique array function

I've been trying to this but I'm having trouble working out a formula in a single cell.
I want to be able to select a range of cells with several unique values and get an array result which counts each of the unique values.
For example, if I have data in a column that looks like this:
a
a
a
b
b
c

There are 3 a's, 2 b's and 1 c.
So I would want an array result that looks like this: 3,2,1
Is this possible?
Any help greatly appreciated!

Cheers
Josh

## Anwsers to the Problem Count unique array function

Hi Biff
Thanks for the answer but it wasn't quite what I was looking for.
It's difficult to explain I guess. I didn't actually mean a results of "3,2,1"
I meant it would give me a result of 3.
Then, if I dragged it down two cells I would get:
3
2
1
Hence the array 3,2,1.
And you're right it's not the end result.
What I want to do is to be able to take the product of the array.
So 3*2*1 = 6.
Any ideas?
That's a nice looking add-in though.

Josh

If you just want something that basically does: 3*2*1 = 6
Array entered** :
=PRODUCT(IF(FREQUENCY(MATCH(A2:A7,A2:A7,0),ROW(A2:A7)-ROW(A2)+1),FREQUENCY(MATCH(A2:A7,A2:A7,0),ROW(A2:A7)-ROW(A2)+1)))
** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key then hit ENTER.
--
Biff
Microsoft Excel MVP

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

## Recommended Method to Repair the Problem: Count unique array function:

### How to Fix Count unique array function with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.