count group

[daniellchiu via OfficeKB.com]

a
a
a
b
b
c
c
c
c
total 7

Hi, there are 3a 2b 4 c
and I want to get Total 7, please help

 

[carlo]

I have NO idea how you calculate to get 7!

could you explain that further?

Carlo

 

[daniellchiu via OfficeKB.com]

Sorry, actually I just want to group all of them and count the no of group,
it should be total = 3
thanks!

I have NO idea how you calculate to get 7!

could you explain that further?

Carlo

a      
a      

[quoted text clipped - 12 lines]

 

[T. Valko]

Try this:

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

--
Biff
Microsoft Excel MVP

Sorry, actually I just want to group all of them and count the no of
group,
it should be total = 3
thanks!

I have NO idea how you calculate to get 7!

could you explain that further?

Carlo

a
a

[quoted text clipped - 12 lines]

 

[daniellchiu via OfficeKB.com]

Its work thanks!!!!

Try this:

Sorry, actually I just want to group all of them and count the no of
group,

[quoted text clipped - 15 lines]

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Its work thanks!!!!

Try this:

Sorry, actually I just want to group all of them and count the no of
group,

[quoted text clipped - 15 lines]

Message posted via
OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200801/1