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.
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
But that doesn't work with filtered rows
- Filter.then select the column where the number has to be put ie visible cells. Then apply the formula. Then press cntrl+enterkey.then it works
And if you apply another filter?