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.
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
- I don't think so sorry
- Does it works. Is it possible
- No. It should not work in same column. Another filter should work in another column only
And if you apply another filter?
- 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
