Prev: formula error
Next: Excel PrintPreview shows fonts in different colour
From: Detin8 on 28 Mar 2010 23:42
Hi,
I am wondering if anyone can help me,

I have a range of dates with information attached to them, i am trying to
figure out how to show only a selected range of them.

e.g. i have a range from 10/07/2008 through to 20/3/2010 i only want to view
the data from 20/3/2009 through to the 20/3/2010.

can any one please show me how i can do this??
From: Gary Keramidas on 28 Mar 2010 23:50
use the autofilter

--


Gary Keramidas
Excel 2003


"Detin8" <Detin8(a)discussions.microsoft.com> wrote in message
news:FCE1FEFD-EE48-429D-9F95-D912F03C65C1(a)microsoft.com...
> Hi,
> I am wondering if anyone can help me,
>
> I have a range of dates with information attached to them, i am trying to
> figure out how to show only a selected range of them.
>
> e.g. i have a range from 10/07/2008 through to 20/3/2010 i only want to
> view
> the data from 20/3/2009 through to the 20/3/2010.
>
> can any one please show me how i can do this??

From: ozgrid.com on 29 Mar 2010 00:09
AutoFilter; http://www.ozgrid.com/Excel/AutoFilters.htm

Or AdvancedFilter; http://www.ozgrid.com/Excel/advanced-filter.htm



--
Regards
Dave Hawley
www.ozgrid.com

"Detin8" <Detin8(a)discussions.microsoft.com> wrote in message
news:FCE1FEFD-EE48-429D-9F95-D912F03C65C1(a)microsoft.com...
> Hi,
> I am wondering if anyone can help me,
>
> I have a range of dates with information attached to them, i am trying to
> figure out how to show only a selected range of them.
>
> e.g. i have a range from 10/07/2008 through to 20/3/2010 i only want to
> view
> the data from 20/3/2009 through to the 20/3/2010.
>
> can any one please show me how i can do this??

 | 
Pages: 1
Prev: formula error
Next: Excel PrintPreview shows fonts in different colour