Forum Discussion
excel numbering in afiltered data
I have a set of data in excel sheet. I have filtered the data as I want. How can I number serialy these filtered data.
15 Replies
Hi Jamal,
This approach allows the sequential number to show dynamically.
- ie , I want to put the number 1,2,3....after filtering.
- As far as I’m aware it’s not possible to drag down to fill a filtered list or auto populate it in sequence while filtered.
It could probably be done with some VBA code.
- Without filtering how can i do this
- Sorry I don’t understand what you mean
- Hi Jamal
Are you able to sort the data before filtering. That would make the numbering easier?
