Just to add to Debra's reply. If you filter by a different criteria (or show
all), your numbers will change since it is a formula.



Debra Dalgleish wrote:

If you want to know the record number, in relation to the visible
records, you could use the following formula, and copy it down to the
end of the list:

=SUBTOTAL(3,$D$2:D2)

where the first row of data in the unfiltered table is row 2, and there
is an entry in every row in column D.

Note: Don't use this technique if you plan to use Excel's Subtotal
feature (DataSubtotals) -- it may delete your table when you remove the
Subtotals.

Maria wrote:
I want to know continously give a serial number skipping in between some rows
that are filtered.

In excel if we try Fill series, it is not working on filtered rows.

Is there any way out? Please help.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson