Menu

Counting the number of consecutive cells/rows that have the same entry

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Chantelle[_2_] Chantelle[_2_] is offline

Chantelle[_2_] is offline

external usenet poster

Posts: 2

Default

Counting the number of consecutive cells/rows that have the same entry

(Chantelle) wrote in message . com...
Hi,
I have tried using the count functions in excell to count the number
of cells that are in consecutive order that have the same value, but I
can not get my head around it. I have rows of data with fixed entries
say A B C D and E and i want to put into the column next to the
entries a formula /vba programme that counts the the numbers above and
below if they = the number in the cell and only until there is a
change in numbers e.g

Column A Column B
A 2
A 2
B 1
C 2
C 2
B 1
D 2
Does anyone have any idea how to solve this problem in VBA?

Reply With Quote

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
Counting the Number of Consecutive Ranges	allan2005CL	Excel Worksheet Functions	0	August 22nd 10 08:46 PM
counting the number of consecutive days 12-17-09	LEG	Excel Worksheet Functions	2	December 18th 09 06:02 PM
Counting the largest number of consecutive 1's in a column	DavidS	New Users to Excel	3	November 17th 06 11:19 AM
Counting number of consecutive zeros at the end of a list	[email protected]	Excel Discussion (Misc queries)	2	September 22nd 05 12:47 PM
cells() and counting number or rows on spreadsheet	HeatherO	Excel Worksheet Functions	7	March 2nd 05 10:36 AM

All times are GMT +1. The time now is 05:03 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement