+ Reply to Thread
Results 1 to 7 of 7

Problem in data filtering

  1. #1
    Registered User
    Join Date
    08-01-2017
    Location
    Athens
    MS-Off Ver
    16
    Posts
    3

    Problem in data filtering

    Hello guys,

    i have encountered a problem while data (date) filtering. Even though the column date has data of up to June, the filters only show "Jan" and "Feb". However, when i tried to use a pivot timeline, it seemed to work smoothly. Can anyone tell me how to make all the dates visible? I also upload a sample of the problem i face. Thank you in a advance.

    YiannisUntitled.png
    Attached Files Attached Files
    Last edited by ychasapis; 08-01-2017 at 09:15 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2412 (Windows 11 24H2 64-bit)
    Posts
    88,706

    Re: Problem in data filtering

    It's a known bug. Please see this recent thread for a workaround: https://www.excelforum.com/excel-new...-in-my-pc.html
    Last edited by AliGW; 08-01-2017 at 09:23 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-01-2017
    Location
    Athens
    MS-Off Ver
    16
    Posts
    3

    Re: Problem in data filtering

    Thank you very much for your prompt response. Could you please send me the url once again, as this one seems broken? Thank you!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2412 (Windows 11 24H2 64-bit)
    Posts
    88,706

    Re: Problem in data filtering


  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2412 (Windows 11 24H2 64-bit)
    Posts
    88,706

    Re: Problem in data filtering

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  6. #6
    Registered User
    Join Date
    08-01-2017
    Location
    Athens
    MS-Off Ver
    16
    Posts
    3

    Re: Problem in data filtering

    Quote Originally Posted by AliGW View Post
    Thank you very very much.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2412 (Windows 11 24H2 64-bit)
    Posts
    88,706

    Re: Problem in data filtering

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with filtering large data sets
    By LeCoquille in forum Excel General
    Replies: 1
    Last Post: 10-17-2016, 03:49 AM
  2. Problem filtering chart data
    By ryanx22 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-08-2016, 03:17 PM
  3. [SOLVED] [SOLVED] Problem Filtering Excel Data
    By msb15 in forum Excel General
    Replies: 10
    Last Post: 12-12-2015, 10:52 PM
  4. Problem with filtering data in a listbox using a combobox value
    By lboromark in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-27-2015, 06:47 AM
  5. [SOLVED] Need help filtering data by filtering based on the last digit of a column/true statement
    By Stephen R in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 07:43 AM
  6. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  7. Data filtering problem - challenging!
    By Cumberland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2007, 04:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1