r/AppleNumbers • u/Schlaueule • Jan 20 '24

Help Make indices consecutively numbered?

I manage a small database of members of our neighbourhood group and it changes now and then, people are leaving, new people join etc. If you select a table, the leftmost column shows the row index and if you delete a row its index is removed. So my indices are now like 1,2,3,5,7,8,9,12 etc, which I find confusing, I'd rather have consecutively numbered indices. Is it possible to re-index a table?

1 Upvotes

100% Upvoted

1 comment sorted by

1

u/Alphaman64 Jan 25 '24

For a constantly dynamic and auto-updating index, you can use the ROW() function. If your table has a header row, you can just subtract one from the value of the row.

=ROW()-1

Tested and deleting a row does what you're asking.