Hi guys

Hope someone can help

Here is an example of what I am trying to do

Cell range A1 - A12

Bob
James
Jill
George
Tracy
Mike
Bob
Philip
Graham
Jack
James
Bob

Different names = 9

Ignore repeated names, except once


What formula would I need to put in cell A13 to give me this figure?

Thank you in advanced


Ravi Sandhu

One way:

A13: =SUMPRODUCT((A1:A12<>"")/COUNTIF(A1:A12,A1:A12&""))

In article <t0BXc.469$(E-Mail Removed)>,
"Ravi Sandhu" <(E-Mail Removed)> wrote:

> Hi guys
>
> Hope someone can help
>
> Here is an example of what I am trying to do
>
> Cell range A1 - A12
>
> Bob
> James
> Jill
> George
> Tracy
> Mike
> Bob
> Philip
> Graham
> Jack
> James
> Bob
>
> Different names = 9
>
> Ignore repeated names, except once
>
>
> What formula would I need to put in cell A13 to give me this figure?
>
> Thank you in advanced
>
>
> Ravi Sandhu