+ Reply to Thread
Results 1 to 2 of 2

Date doesn't work properly with Filter

  1. #1
    Registered User
    Join Date
    07-19-2017
    Location
    California
    MS-Off Ver
    2010
    Posts
    1

    Date doesn't work properly with Filter

    I have a file which stores client information of a company for a month.
    The file stores information of every day in the month (updates daily).
    Today is the 20.07.2017, so I have information of 20 days.

    A row in the file looks like that: Date - Name - Other things...

    When I try to filter a specific Name, the filter only shows me results up to the 12.07.2017 (included), excluding the other dates.
    I can't figure out what is going on, so I hope you can help me with that.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Date doesn't work properly with Filter

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. $ in formula doesn't work properly, please help?
    By BeHereALot in forum Excel General
    Replies: 2
    Last Post: 04-13-2017, 08:24 PM
  2. [SOLVED] Autofilter doesn't work properly?
    By kormanyp79 in forum Excel General
    Replies: 5
    Last Post: 12-04-2013, 09:18 AM
  3. VBA function doesn't work properly
    By sumonrezadu in forum Excel General
    Replies: 4
    Last Post: 08-28-2009, 09:38 AM
  4. Vlookup doesn't work properly
    By HuskerBronco in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2009, 12:49 PM
  5. Button doesn't work properly
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2009, 05:53 AM
  6. Interface doesn't work properly. Why ?
    By BorisMKD in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-02-2009, 10:27 AM
  7. Workbook_Open Doesn't Work Properly
    By Ferg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2005, 03:05 AM

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