Frequency of Unique Values

[systemsteve]

Thanks for all the help - useful to know.

However, I've just realised that I actually didn't describe what I actually needed.

Instead of showing the MAX value in my previous example, I wanted to count the number of unique values for Option 1 and Option 2.

Example

A B
---------------
Option 1 10
Option 1 10
Option 2 8
Option 1 27
Option 2 43
Option 2 28


So the formula would return the following results;

Option 1 count = 2
Option 2 count = 3


I tried to use the above examples with a SUM< IF FREQUENCY formula, but it didn't seem to carry through.

The value range that I am counting includes numbers arrived at through formulae.

Hope that makes sense.

[NBVC]

If your table is in A1:B6 and you listed Option 1 and Option 2 in A9:A10, then in B9 enter:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and then copy down.

[systemsteve]

Outstanding. That works perfectly.

Many Thanks