Previous Topic Next Topic

Auto filter problem

Solved/Closed
miteshmech87 Posts 1 Registration date Thursday November 29, 2012 Status Member Last seen November 29, 2012 - Nov 29, 2012 at 12:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2012 at 07:35 AM
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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 1, 2012 at 07:35 AM
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
0