Add to the count if the cell contains a specific name...

[copperwasher]

Hello Excel Gurus,

Over the past couple of hours, I have made some feeble attempts at this.

I need to display a rolling count (column 2), but the count is relative to a specific name (column 1).

Column 1 is typed.
Column 2 is the desired output.

Column 1, will grow in length, as more data is added, so column 2 needs to be able to copy down also

COMPANY NAME (column 1)	COMPANY NAME and COUNT (Column 2)
company B	company B 101
company A	company A 101
company A	company A 102
company A	company A 103
company C	company C 101
company C	company C 102
company B	company B 102
company A	company A 104
company A	company A 105

Any assistance is very much appreciated,

My regards
Gary

 

[Fluff]

How about

Fluff.xlsm
	A	B
1	Name	Count
2	company B	company B 101
3	company A	company A 101
4	company A	company A 102
5	company A	company A 103
6	company C	company C 101
7
8	company B	company B 102
9	company A	company A 104
10	company A	company A 105
Master

Cell Formulas
Range	Formula
B2:B10	B2	=IF(A2="","",A2&" "&100+COUNTIFS(A$2:A2,A2))

 

[copperwasher]

How about

Fluff.xlsm
	A	B
1	Name	Count
2	company B	company B 101
3	company A	company A 101
4	company A	company A 102
5	company A	company A 103
6	company C	company C 101
7
8	company B	company B 102
9	company A	company A 104
10	company A	company A 105
Master

Cell Formulas
Range	Formula
B2:B10	B2	=IF(A2="","",A2&" "&100+COUNTIFS(A$2:A2,A2))

That is perfect

Now I need to work out, how it works...

Thank you Fluff

 

[Fluff]

Glad we could help & thanks for the feedback.