Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 24th 18, 11:35 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 2
Default Problems filtering dates

I have a column with dates, starting with 05-04-2018 in B2 and ending with 06-05-218 in B34. When I try to use date filters, and only want to see dates from May, is displays those dates + the last date, that is June 5th. No matter how I try to apply a filter, I do not seem to be able to get rid of the last date.

If i delete some of the dates, so that only a single date in June is shown, it is still shown if I filter on May. Even if I try to apply a filter that shows only one date, say 05-22-2018, the last date in the column is shown as well.

Any ideas how to get by this?

Jan

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering problems KW Excel Worksheet Functions 1 May 29th 08 05:20 PM
Problems with filtering and output floep[_2_] Excel Programming 3 July 28th 06 12:49 PM
Problems with filtering and output floep Excel Programming 1 July 27th 06 03:45 PM
Problems with filtering and output floep[_3_] Excel Programming 1 July 27th 06 03:44 PM
Problems with filtering!! Barry Jive Excel Programming 3 June 22nd 05 08:50 AM


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017