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