Posted to microsoft.public.excel.programming

JP[_8_]

external usenet poster

Posts: 4

Count each group of values

I need a formula or vba code to count how many groups of "X" values and how
many "X" in each group.
Sample:

a1
ah1
X X X X X X X A A A A X X X X X X B B B B B B X X X X X X X X X X X X

Result i need with the code or formula
1 group 7 "x"
2 group 6 "x"
3 group 12"x"

Thanks for help
Paulo

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to count an age group	Call me Ana, Ana Pego	New Users to Excel	2	October 20th 08 12:43 AM
To count how many are in a certain age group	LEG	Excel Worksheet Functions	10	May 8th 08 06:23 AM
count group	daniellchiu via OfficeKB.com	Excel Discussion (Misc queries)	5	January 10th 08 04:35 AM
Count Distinct Values by Group Using Pivot Table (NM)	MCP	Excel Worksheet Functions	3	February 11th 05 09:22 PM
count a group of numbers but do not count duplicates	Lisaml	Excel Worksheet Functions	2	January 26th 05 11:19 PM

All times are GMT +1. The time now is 02:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us