PDA

View Full Version : Sorting issue in Excel


jakester
Mar 6, 2009, 11:24 AM
Hello -

I've been working with an Excel Spreadsheet and I have run into a problem with it. I have a filter set up and I when I want to filter on a specific thing like "blanks" or "non-blanks", at the lower left hand corner of the screen it will tell me the count: "5 of 25 records found." For some reason now when I sort, it longer provides me the count in the lower left corner. Is there some way to turn this feature back on?

Thanks.

JBeaucaire
Mar 6, 2009, 12:18 PM
What appears there now? "Filter"? This is a common situation once you start playing with the filtered results. You only get the 5 of 25 when the data hasn't been fiddled with in any way.

Rather than go into the details all over again, read a full explanation of this issue here. Hope this helps.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213886