count group
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

count group
 

I have NO idea how you calculate to get 7!

could you explain that further?

Carlo

On Jan 10, 11:49*am, "daniellchiu via OfficeKB.com" <u36625@uwe
wrote:
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

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

count group
 

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

carlo wrote:
I have NO idea how you calculate to get 7!

could you explain that further?

Carlo

On Jan 10, 11:49Â*am, "daniellchiu via OfficeKB.com" <u36625@uwe
wrote:
a Â* Â* Â*
a Â* Â* Â*
[quoted text clipped - 12 lines]
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200801/1

--
Message posted via http://www.officekb.com

count group
 

Try this:

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

--
Biff
Microsoft Excel MVP


"daniellchiu via OfficeKB.com" <u36625@uwe wrote in message
news:7dfb3ad4bbe2f@uwe...
Sorry, actually I just want to group all of them and count the no of
group,
it should be total = 3
thanks!

carlo wrote:
I have NO idea how you calculate to get 7!

could you explain that further?

Carlo

On Jan 10, 11:49 am, "daniellchiu via OfficeKB.com" <u36625@uwe
wrote:
a
a
[quoted text clipped - 12 lines]
--
Message posted via
OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200801/1

--
Message posted via http://www.officekb.com

count group
 

Its work thanks!!!!

T. Valko wrote:
Try this:

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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

count group
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"daniellchiu via OfficeKB.com" <u36625@uwe wrote in message
news:7dfbb523ffd0e@uwe...
Its work thanks!!!!

T. Valko wrote:
Try this:

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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1