Hi Mike,

Many Thanks for your reply and help, and the examples are great but I need
to go futher, I need to ascertain the number of Agents (Column B) for each of
the Categories in column A and C and were the same agent can be in both
category in Column A... in fact I need to get the Total Unique Names of New
Hire/Ternured for each of the Category DC&D/AIO.

Regs,

"Mike H" wrote:

Hi,

I'm not sure if you want each column or a single count for the 3 columns.
Try these ARRAY formula

All Columns
=SUM(IF(LEN(A1:C23),1/COUNTIF(A1:C23,A1:C23)))

A single column. Drag right for cols B & C
=SUM(IF(LEN(A1:A23),1/COUNTIF(A1:A23,A1:A23)))

These are array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Vitordf" wrote:

Hi,

I saw a few formulas that adds Unique records when is numbers, but I have a
spreasheet which I need to count the Unique records (Names) taken into
consideration three diffrent columns, example;
Column A Column B Column C
DC&D aagis Ternure
DC&D aagis Ternure
DC&D adamk New Hire
DC&D adamk New Hire
DC&D adasilva New Hire
DC&D adasilva New Hire
DC&D vdafons Ternure
DC&D AMPATA Ternure
DC&D AMPATA Ternure
DC&D AMPATA Ternure
DC&D AMPATA Ternure
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO Ashaw New Hire
AIO buyssp Ternure
AIO buyssp Ternure
AIO buyssp Ternure
AIO buyssp Ternure
AIO buyssp Ternure

Hope someone could help me.

Many Thanks,