Count Unique Items

R

Regan

Hello there,
Simple question here that I can't seem to find the answer
for in Microsoft Excel Help. How do I count unique
entries within a selection of cells (column)? Ie - there
are numerous entries the same, but within a count
function, I would like only one instance of each counted.

Thanks in advance.
 
R

Regan

Thanks Frank, I'm still a little confused as to how that
works. What I'm trying to achieve is showed in this
example:

Mark
Bryan
Mark
Mark
Terry
Terry

The answer to this should be 3 - ie. 3 unique entries in
the column. is the formula you mentioned correct for this?
 
R

Regan

Hi Frank,
Please ignore my last comment, have sorted it out. Thanks
for your help. Spot on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting unique instances of a text string 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Macro to Select text from a point given to a specific word 2
Fill cells based on the other 3 cells unique combination the value on the target cell 0
WORD VBA Search and switch to advanced ... 1
count unique items 1
count unique in non-continuous list 3
Count columns that meet criterias 3

Top