Re: Database
- From: frankt <frankt@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Apr 2005 10:19:02 -0700
Another solution would be to add additional columns that refer to the date
using this formula (Assumes Date is in column C
=TEXT(C3,"mmm")
It would be an absolute text string an filter will work just fine. If you
need year also then another syntax might be:
=TEXT(C3,"yy-mmm")
Regards,
Frank T
"JulieD" wrote:
> Hi
>
> not sure why filter didn't work for you ... did you try clicking on the date
> column drop down arrow, choosing custom and then
> greater than or equal to 4/1/05
> and
> less than or equal to 4/30/05
>
> where you're looking for the current month (change dates as applicable)
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "insdoc" <insdoc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:C9BD4B98-2391-4C98-ADF9-2E434392DC1C@xxxxxxxxxxxxxxxx
> >I have a spreadsheet that includes 500 rows and 15 columns. The data
> >includes
> > Name, Address, Phone per column and 2 columns of effective dates, one for
> > each contract. I am trying to create a report that will give me the name
> > of
> > each individual where each contract expires in a given month. I have
> > formated
> > the columns to show months only. have tried Filter and Pivot but neither
> > work. I need an "AND" solution.
> >
> > ANy help would be appreciated.
> >
> > Jim
>
>
>
.
- References:
- Database
- From: insdoc
- Re: Database
- From: JulieD
- Database
- Prev by Date: Excel 2003 Multi-worksheet copy via drag/drop
- Next by Date: Re: Lookup value
- Previous by thread: Re: Database
- Next by thread: Re: Database
- Index(es):
Relevant Pages
|
