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.
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.
It could probably be done with some VBA code.
does it can be done through MAX function. please download the attachment and view. I want to do like this
That only works with SUBTOTAL or AGGREGATE as Wyn suggested - apply formula before filtering and numbers will be recalculated upon each filtering
yes i got it..=MAX($j$1:j3)+1, where j is the column name. and 3 is the nmber just before the data begins
