How to use a formula to show the row # in a cell

Bert Hoffbeck

I'm exporting a sheet and am trying to show the specific row number for each record.

Do you know if there is a formula (i.e. =row) that will populate a cell in that record row?

Sherry Fox

Following for this one. I would love this ability. Far too often the auto number gets messed up. I have to work with sheets where people DELETE records (makes me scream).

Scott Orsey

Hi @Sherry Fox and @Bert Hoffbeck , I've seen several options for doing this in the Community. The one I use is to go ahead and create an Auto Number column. I'll call it RowID. Then create a second column called [Row #] with the column formula:

= MATCH(RowID@row,RowID:RowID,0)

This will return the index (row number) of the RowID that matches the RowID of the current row. If you already have a column that you know will have unique values in it, you can use that instead of RowID and save yourself a column 😀

Good luck!

Be well

Bert Hoffbeck

Scott.

Thank you - your formula works!

Bert

Sherry Fox

@Scott Orsey ,

That worked great, thanks for the assistance!!!

MikeChambers

@Scott Orsey, you are a Rock Star!