Forum Discussion
Re: excel numbering in afiltered data
That only works with SUBTOTAL or AGGREGATE as Wyn suggested - apply formula before filtering and numbers will be recalculated upon each filtering
7 Replies
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
