ExcelBanter - filter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - filter (https://www.excelbanter.com/excel-worksheet-functions/154987-filter.html)

zolabus

filter

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?

Bernie Deitrick

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?

All times are GMT +1. The time now is 06:58 AM.