filter

Z

zolabus

Hi and sorry for my english
when i use the authomatic filter i need that the results are numbered in a
near column.
Is it possible?
 
B

Bernie Deitrick

zolabus,

For example, insert a new column A, and put this formula into cell A2

=SUBTOTAL(3,$B$2:B2)

Then copy down to match your unfiltered list. When you filter, the numbers will update.

HTH,
Bernie
MS Excel MVP
 
Top