Forum Discussion
JAMAL MUHAMMED A
Jul 02, 2018Copper Contributor
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.
SergeiBaklan
Jul 03, 2018Diamond Contributor
But that doesn't work with filtered rows
JAMAL MUHAMMED A
Jul 03, 2018Copper Contributor
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
- Wyn HopkinsJul 05, 2018MVPI don't think so sorry
- JAMAL MUHAMMED AJul 03, 2018Copper ContributorDoes it works. Is it possible
- JAMAL MUHAMMED AJul 03, 2018Copper ContributorNo. It should not work in same column. Another filter should work in another column only
- SergeiBaklanJul 03, 2018Diamond Contributor
And if you apply another filter?