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