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

  • Thread starter Thread starter Dhruva101
  • Start date Start date
D

Dhruva101

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
 
=COUNTIF(A:A,A2)

and copy down.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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
 
Thank you Guys, Works Great. It was a very quick response.. Really
appreciate your replies..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Extracting data from Multiple columns to a Single row 1
SUMIFS ONLY UNTIL the number REPEATS 1
Return value in an table with variable columns and rows 2
moving rows to another sheet 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top