Thread: filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default filter

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


"zolabus" wrote in message
...
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?