# Find the number of a row in a table-dynamic

#### stratis

##### Board Regular
Goodmorning,

I would like to find the number of the first row in a table with filters.

The number of the row should change depending on the data appears every time.

Eg.

Table

A/A Name
1 AB
2 AC

In this tabel i would to make a cell that appears to me the row number of cell 2 if I select (filter) the table so as to appears only the AC and the row number of cell 3 if filter to appears only th AD (the first time).

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
0
Views
108
Replies
5
Views
140
Replies
4
Views
112
Replies
2
Views
181
Replies
0
Views
202

1,129,804
Messages
5,638,450
Members
417,025
Latest member
MusterDuster

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back