counting rows

[Darryl]

I have 100 rows in a column A which are numbered 1 -100 in numical order.
After I filter a particular item in column B which results in 20 rows (and
these 20 item were scattered throughout the column), I would like column A to
show 1 - 20 in numerical order.

 

[T. Valko]

Try this...

Assume the data in column B is in the range B2:B1010 with B1 being the
header.

Enter this formula in A2 and copy down to A101:

=SUBTOTAL(3,B$2:B2)

 

[מיכ×ל (מיקי) ×בידן]

Assuming you have headers in row 1 and the 100 items are in range B2:B101, -
in cell A2 type: =SUBTOTAL(103,$B$2:B2) and copy down along the range.
Try, now, to filter an item in column B.
Micky