How to check if current cell is in first row of table?

Question

I need to check if the current cell in the table is on the first row. It must check inside the it's own table, not just the sheet. I couldn't find any info on this. Is this possible using a formula? I want to do a special operation if this is the case.

Answer 1

Using native worksheet functions to construct a simple formula, you can retrieve the relative row position within the ListObject (aka structured) table by subtracting the header row.

=ROW()-ROW(Table1[#Headers])

The result could be compared to 1 to return a boolean result determining if you are in the first row of the table.