Posted to microsoft.public.excel.worksheet.functions

[email protected] administrator@vicfam.com.au is offline

external usenet poster

Posts: 1

Count consecutive occurances

I'm looking lo count the number of consecutive occurances of a 1
without a zero in a table but only if it is a new run. i.e.

Data Result
0 0
1 1
0 0
1 0
1 0
1 3
0 0

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
Need to count occurances in different columns	More Macro Help Needed	Excel Worksheet Functions	2	December 21st 06 05:20 PM
Count # of unique occurances	sharder	Excel Worksheet Functions	3	June 29th 06 05:12 AM
count matching occurances	campfire51	Excel Worksheet Functions	0	March 15th 06 09:31 PM
Count occurances Problem	Ed Gregory	Excel Worksheet Functions	3	September 9th 05 08:06 PM
Count occurances of multiple values	BaseballFan	Excel Worksheet Functions	2	February 17th 05 08:31 AM

All times are GMT +1. The time now is 10:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us