Auto filter problem

[Solved/Closed]
Report
Posts
1
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 29, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further behind then overall last blank cell.

For example i have prepared an excel in which i am giving sequnce numbering for particular code like FG ,BFL etc. presently i have blank cell no 450,Now when i am filtering BFL for adding sequnce number in that the last blank cell i am getting is 10475 instead of 450 which is the last overall blank cell. this will result in lots blank cell between overall excell enteries.


Please suggest some idea what to do for that

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am not too sure what you were asking. The best that I could make was that you want to filter for blank and it is only showing the last blank. Prior to putting the filter mode on for the sheet, select all the cells and then apply turn on the filter, and then look for the value