Adding Row Number to Table

Greetings Klipfolio Community!


The following will detail how to add a column to your table, which simply contains the row number of each entry.

This can be accomplished using a combination of the CUMULATIVE, COUNTALL, and REPEAT functions.

Lets say you have the following table;


And you wanted to add a column containing row number.

You can use the below formula to get the row number.

Please note that the parameter of the COUNTALL function is a reference to the first column.

CUMULATIVE//Add array of ones together

      REPEAT//Array of ones eg{1,1,1...}


And voila!


Happy Klipping!

Joshua Cohen-Collier


Please sign in to leave a comment.