copperwasher
Board Regular
- Joined
- Mar 1, 2016
- Messages
- 84
- Office Version
- 365
- Platform
- Windows
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
Any assistance is very much appreciated,
My regards
Gary
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