How to copy the row number in a column.

Vaibhav Bendre

How to copy the row number in a column. In attached snap, i want to copy the row Number 8 under TestIDID column automatically. Do we have any pointers for the same.

Row Number.png

KPH

Hi

You need to have something unique in each row of the sheet. If you don't have anything, you can add and hide an Auto number column. Then you can use a MATCH formula like this:

=MATCH([Unique ID]@row, [Unique ID]:[Unique ID], 0)

Unique ID is the column name that contains the unique piece of information. This could be the auto number column or any ID you already have.

This will return the row number of the row where the Unique ID matches the Unique ID on the current row. Which is a complicated way of saying "current row"

KPH

Hi

You need to have something unique in each row of the sheet. If you don't have anything, you can add and hide an Auto number column. Then you can use a MATCH formula like this:

=MATCH([Unique ID]@row, [Unique ID]:[Unique ID], 0)

Unique ID is the column name that contains the unique piece of information. This could be the auto number column or any ID you already have.

This will return the row number of the row where the Unique ID matches the Unique ID on the current row. Which is a complicated way of saying "current row"

Vaibhav Bendre

Hi KPH,

Thanks for your response.

KPH

No problem. Hope it helped.

Vaibhav Bendre

Yes KPH. Its worked.

KPH

Wonderful!