Auto count increment based on data from another column

[KNguyen]

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

[mceleavey]

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.

[mceleavey · Accepted solution]

@KNguyen 

and here it is with the multi-row:

M.

[KNguyen]

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.