counting rows

  • Thread starter Thread starter Darryl
  • Start date Start date
D

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.
 
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
 
Back
Top