How do I increment count based on a column? Sample Col ACol B70000207111113700002181110127000022111101270000232111012700002341110127000023911101270000240111012700002421110127000024511101270000245504083 End Result - Count increment based on column A above. NumberCol ACol B170000207111113170000218111012170000221111012170000232111012170000234111012170000239111012170000240111012170000242111012170000245111012270000245504083

Auto count increment based on data from another column

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

Tips and Tricks

Accepted answers

mceleavey

@KNguyen

and here it is with the multi-row:

mceleavey_solution.yxmd

All comments

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,

mceleavey_solution.yxmd

mceleavey

@KNguyen

and here it is with the multi-row:

mceleavey_solution.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703