Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Sorting issue in Excel (https://www.askmehelpdesk.com/showthread.php?t=325784)

  • Mar 6, 2009, 11:24 AM
    jakester
    Sorting issue in Excel
    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.
  • Mar 6, 2009, 12:18 PM
    JBeaucaire

    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...;EN-US;q213886

  • All times are GMT -7. The time now is 01:07 PM.