Previous Topic Next Topic

Auto filter problem

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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
1 Dec 2012 à 07:35
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

Similar discussions

Any auto clicker for Xbox One?
vic11con -
julietdcosta -

13 responses