Counta column B for each change in column A in excel

[treta]

Hi
I can't achive this, so please help me with VBA
(I tried with some Do While rng.Row > intRow but not working)


Column A Column B Column C
Employe typeA John 2
Mary
Employe typeB Steve 1

thanks

 

[SkipVought]

Hi,

Why do you not have a proper table: with EmployeeType in each row?

If your did, it would be a piece of cake WITHOUT VBA code, using spreadsheet functions.

This looks like some sort of report, which is not a good source for performing data analysis and reporting.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[treta]

Well, someone asks me for a help with this.

I'm triyng but I didnt find a solution - yet, I hope

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

First, you need to have UNIQUE HEADINGS in row 1.

I would propogate the missing values in a new column using a spreadsheet formula, lets assume in D2...
[tt]
D2: =if(A1=A2,D1,A2)
[/tt]
Then generate the aggregation using the PivotTable wizard. It's a 5 minute task.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]