A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Advanced Filter using Date represented as text



 
 
Thread Tools Display Modes
  #1  
Old December 14th 04, 09:49 PM
drice
external usenet poster
 
Posts: n/a
Default Advanced Filter using Date represented as text

I am trying to do an advanced filter using data in one spreadsheet and
filtering to another. The source spreadsheet (called Source) has a column of
dates (Column O, Name=Dates) that are text representations vs. Excel date
formats. I want to filter the data from the source to another workbook
(called Destination).

In the Destination, I have a spreadsheet with criteria (called Criteria) and
a spreadsheet that I want the filtered data to go into (called Data). I
haven't quite figured out how to get the filter to work. Currently, I have
criteria range that looks like
A B
1 Dates
2 =DATEVALUE(Data!O2)>B$2 1-Jun-2004

Source spreadsheet, Column O looks like
Dates
05-JUL-2004
01-FEB-2006
03-AUG-2004

I perform the extract and get not records.
I've also tried to simplify the problem a bit by putting the criteria into
the Data tab with no luck.
I have done the extract by first converting the Dates column to Excel date
format and using a different formulat in the but this is an extra step that I
would like to avoid.


--
drice
Ads
  #2  
Old December 15th 04, 04:56 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default

Hi
I think you better try to convert your date values first to real Excel date
values. All other solution probably won't work that well with a filter

--
Regards
Frank Kabel
Frankfurt, Germany
"drice" > schrieb im Newsbeitrag
...
>I am trying to do an advanced filter using data in one spreadsheet and
> filtering to another. The source spreadsheet (called Source) has a column
> of
> dates (Column O, Name=Dates) that are text representations vs. Excel date
> formats. I want to filter the data from the source to another workbook
> (called Destination).
>
> In the Destination, I have a spreadsheet with criteria (called Criteria)
> and
> a spreadsheet that I want the filtered data to go into (called Data). I
> haven't quite figured out how to get the filter to work. Currently, I
> have
> criteria range that looks like
> A B
> 1 Dates
> 2 =DATEVALUE(Data!O2)>B$2 1-Jun-2004
>
> Source spreadsheet, Column O looks like
> Dates
> 05-JUL-2004
> 01-FEB-2006
> 03-AUG-2004
>
> I perform the extract and get not records.
> I've also tried to simplify the problem a bit by putting the criteria into
> the Data tab with no luck.
> I have done the extract by first converting the Dates column to Excel date
> format and using a different formulat in the but this is an extra step
> that I
> would like to avoid.
>
>
> --
> drice



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting data from a website changes text to date stebro Excel Discussion (Misc queries) 8 August 12th 06 08:39 PM
Advanced Filter Problems Brian Excel Discussion (Misc queries) 2 December 20th 04 06:31 PM
Advanced Filter: No Filter Evan Weiner - Richalnd WA Excel Discussion (Misc queries) 2 December 9th 04 04:36 PM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM
& reference answering as Date Serial # not actual text Kevin M Excel Worksheet Functions 0 November 30th 04 05:57 PM


All times are GMT +1. The time now is 12:31 AM.


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