How do I increment count based on a column?
Sample
Col A | Col B |
70000207 | 111113 |
70000218 | 111012 |
70000221 | 111012 |
70000232 | 111012 |
70000234 | 111012 |
70000239 | 111012 |
70000240 | 111012 |
70000242 | 111012 |
70000245 | 111012 |
70000245 | 504083 |
End Result - Count increment based on column A above.
Number | Col A | Col B |
1 | 70000207 | 111113 |
1 | 70000218 | 111012 |
1 | 70000221 | 111012 |
1 | 70000232 | 111012 |
1 | 70000234 | 111012 |
1 | 70000239 | 111012 |
1 | 70000240 | 111012 |
1 | 70000242 | 111012 |
1 | 70000245 | 111012 |
2 | 70000245 | 504083 |
Solved! Go to Solution.
Hi @KNguyen ,
I did this simply by adding a number column, and using the Running Total tool.
You can also do it with a multi-row but this was means you don't need to write a formula.
I hope this helps,
M.
Oh this is awesome! The multi-row tool. I wasn't able to get the running total to work. But got the multi-row tool to work. The running total, for some reason the create running total section doesn't show the number field i created.