Prev: pivot tableNext: Convert Time From: Darryl on 28 Jan 2010 15:53 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. From: T. Valko on 28 Jan 2010 16:59 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) -- Biff Microsoft Excel MVP "Darryl" wrote in message news:89190AE3-6D26-4F2C-9C2D-51EB5312CB1D(a)microsoft.com...>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. From: מיכאל (מיקי) אבידן on 29 Jan 2010 05:27 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 "Darryl" wrote: > 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.  |  Pages: 1 Prev: pivot tableNext: Convert Time