Count the rows if the previous rows value is same as the next row value

's Computer Specifications

Following is a piece of example of my spread sheet.
The spread sheet is sorted on job name which is the first column and
the second column is the program name.
I need to find how many programs are impacted for each job.
I need that count to be displayed on the count column(3rd Column).
For the following example, the count for AB25DX will be 1, for BBB9MX
will be 4, for BBB9WX will be 1 and for BBB1WX will be 2.

Could some one help me in automating this process ?

Job Name program Name count
AB25DX AIC920
BBB9MX AUC230
BBB9MX AUC231
BBB9MX AVD224
BBB9MX AVD225
BBB9WX AVD222
BBB1WX ACD366
BBB1WX AVD217

--
Dhruva101
------------------------------------------------------------------------
Dhruva101's Profile: http://www.excelforum.com/member.php...o&userid=37074
View this thread: http://www.excelforum.com/showthread...hreadid=567995

's Computer Specifications

=COUNTIF(A:A,A2)

and copy down.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dhruva101" <(E-Mail Removed)> wrote
in message news

(E-Mail Removed)...
>
> Following is a piece of example of my spread sheet.
> The spread sheet is sorted on job name which is the first column and
> the second column is the program name.
> I need to find how many programs are impacted for each job.
> I need that count to be displayed on the count column(3rd Column).
> For the following example, the count for AB25DX will be 1, for BBB9MX
> will be 4, for BBB9WX will be 1 and for BBB1WX will be 2.
>
>
> Could some one help me in automating this process ?
>
>
> Job Name program Name count
> AB25DX AIC920
> BBB9MX AUC230
> BBB9MX AUC231
> BBB9MX AVD224
> BBB9MX AVD225
> BBB9WX AVD222
> BBB1WX ACD366
> BBB1WX AVD217
>
>
> --
> Dhruva101
> ------------------------------------------------------------------------
> Dhruva101's Profile:
http://www.excelforum.com/member.php...o&userid=37074
> View this thread: http://www.excelforum.com/showthread...hreadid=567995
>

's Computer Specifications

Take a look at Data > Subtotals feature........follow the menu to get a count
on the column desired for each change.........

hth
Vaya con Dios,
Chuck, CABGx3

"Dhruva101" wrote:

>
> Following is a piece of example of my spread sheet.
> The spread sheet is sorted on job name which is the first column and
> the second column is the program name.
> I need to find how many programs are impacted for each job.
> I need that count to be displayed on the count column(3rd Column).
> For the following example, the count for AB25DX will be 1, for BBB9MX
> will be 4, for BBB9WX will be 1 and for BBB1WX will be 2.
>
>
> Could some one help me in automating this process ?
>
>
> Job Name program Name count
> AB25DX AIC920
> BBB9MX AUC230
> BBB9MX AUC231
> BBB9MX AVD224
> BBB9MX AVD225
> BBB9WX AVD222
> BBB1WX ACD366
> BBB1WX AVD217
>
>
> --
> Dhruva101
> ------------------------------------------------------------------------
> Dhruva101's Profile: http://www.excelforum.com/member.php...o&userid=37074
> View this thread: http://www.excelforum.com/showthread...hreadid=567995
>
>

's Computer Specifications

Thank you Guys, Works Great. It was a very quick response.. Really
appreciate your replies..

--
Dhruva101
------------------------------------------------------------------------
Dhruva101's Profile: http://www.excelforum.com/member.php...o&userid=37074
View this thread: http://www.excelforum.com/showthread...hreadid=567995

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel count rows and add equal rows when matched	donlincolnpcr	General Software	0	7th Mar 2010 11:42 AM
Excel VBA count rows from certain point and insert rows	Valerie	Microsoft Outlook VBA Programming	2	27th Nov 2007 02:27 PM
Count number of rows, where non relevant rows are hidden	=?Utf-8?B?UGlldGVy?=	Microsoft Excel Misc	2	8th Nov 2006 12:24 PM
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95?	Dennis@NoSpam.com	Microsoft Excel Misc	12	22nd Jul 2005 12:50 PM
Counters?, Count Rows?, Get Rows? in an Excel Macro	=?Utf-8?B?Q19UQjI0?=	Microsoft Excel Programming	2	3rd Feb 2005 04:29 PM