Keep RowID formula from counting deleted rows

[mallika]

Hi Brandon,
I use Rank instead of row id to handle this - take a look at -

Consecutive Row Numbers?

I know there must be a simple solution to this, but I cannot find it for the life of me. So, I need to have a column where each row has a unique consecutive number ranging from 1 to however many rows I have. I cant use rowId because if I delete any rows and then add new ones, the number will be wrong. Such a simple problem, but it is holding nearly all of my docs back from being made correctly