counta formula that doesn't count duplicates
 

I have excel 2003
How can I create a formula that counts items in a column without counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't seem to
come up even though other new questions have popped in.
thanks Meenie

counta formula that doesn't count duplicates
 

Hi,

Try this with the range adjusted to suit

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Mike

"Meenie" wrote:

I have excel 2003
How can I create a formula that counts items in a column without counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't seem to
come up even though other new questions have popped in.
thanks Meenie

counta formula that doesn't count duplicates
 

thanks Mike, that works! :) :)

"Mike H" wrote:

Hi,

Try this with the range adjusted to suit

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Mike

"Meenie" wrote:

I have excel 2003
How can I create a formula that counts items in a column without counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't seem to
come up even though other new questions have popped in.
thanks Meenie

counta formula that doesn't count duplicates
 

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

You're asking for the wrath of Bernd! <g

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
Hi,

Try this with the range adjusted to suit

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Mike

"Meenie" wrote:

I have excel 2003
How can I create a formula that counts items in a column without counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't seem
to
come up even though other new questions have popped in.
thanks Meenie

counta formula that doesn't count duplicates
 

Biff,

Not unusual for me these days, I'm being a bit slow!!

You're asking for the wrath of Bernd! <g

Why?

Mike

"T. Valko" wrote:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

You're asking for the wrath of Bernd! <g

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
Hi,

Try this with the range adjusted to suit

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Mike

"Meenie" wrote:

I have excel 2003
How can I create a formula that counts items in a column without counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't seem
to
come up even though other new questions have popped in.
thanks Meenie


.

counta formula that doesn't count duplicates
 

Ah,

I see what you mean Bernd seems to have reservations regarding that method.
Hope he doesn't spot my response ;(

http://www.sulprobil.com/html/count_unique.html

Mike

"T. Valko" wrote:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

You're asking for the wrath of Bernd! <g

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
Hi,

Try this with the range adjusted to suit

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Mike

"Meenie" wrote:

I have excel 2003
How can I create a formula that counts items in a column without counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't seem
to
come up even though other new questions have popped in.
thanks Meenie


.

counta formula that doesn't count duplicates
 

Yeah, that's it.

Seems every time I suggest a formula for counting uniques Bernd always finds
me and "chastizes" me for my suggestion.

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
Ah,

I see what you mean Bernd seems to have reservations regarding that
method.
Hope he doesn't spot my response ;(

http://www.sulprobil.com/html/count_unique.html

Mike

"T. Valko" wrote:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

You're asking for the wrath of Bernd! <g

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
Hi,

Try this with the range adjusted to suit

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Mike

"Meenie" wrote:

I have excel 2003
How can I create a formula that counts items in a column without
counting
duplicates?
sorry if this comes through twice, I entered it once and it doesn't
seem
to
come up even though other new questions have popped in.
thanks Meenie


.

counta formula that doesn't count duplicates
 

Hello Biff, hello Mike,

Not today.

Have a Merry Christmas (tomorrow),
Bernd

counta formula that doesn't count duplicates
 

Bernd always finds me

See what I mean? LOL

Merry Christmas, Bernd!

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Hello Biff, hello Mike,

Not today.

Have a Merry Christmas (tomorrow),
Bernd

counta formula that doesn't count duplicates
 

Biff, Bernd,

On reflection I won't recommend that formula again I'll recommend the much
faster alternative. Goodnight both and a very happy Christmas.

Sincerely,

Mike

"T. Valko" wrote:

Bernd always finds me

See what I mean? LOL

Merry Christmas, Bernd!

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Hello Biff, hello Mike,

Not today.

Have a Merry Christmas (tomorrow),
Bernd


.