filter information

I am trying to do a spreadsheet with age, sex and name on. I need to be able
to pick out people from the spreadsheet that are for example, 20, male and
called Bob. How do I do this? Thanks

JoAnn
Mon May 12 08:21:09 PDT 2008

Ideally you would do this in Access with a single query.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


"Vickie" <Vickie@discussions.microsoft.com> wrote in message
news:69E50CEA-09C5-4C9A-8E77-DED5C89B754E@microsoft.com...
>I am trying to do a spreadsheet with age, sex and name on. I need to be
>able
> to pick out people from the spreadsheet that are for example, 20, male and
> called Bob. How do I do this? Thanks

Buckland
Mon May 12 09:04:32 PDT 2008


Hi Vickie,

If your data is in Excel you may want to use the link below to also post in the MS Office Excel discussion group and include there
the version of Excel you're using as the location of features and their abilities can differ by version.

==============
<<"Vickie" <Vickie@discussions.microsoft.com> wrote in message news:69E50CEA-09C5-4C9A-8E77-DED5C89B754E@microsoft.com...
I am trying to do a spreadsheet with age, sex and name on. I need to be able
to pick out people from the spreadsheet that are for example, 20, male and
called Bob. How do I do this? Thanks>>
--
Please let us know if this has helped,

Bob Buckland ?:-)
MS Office System Products MVP

>>*Courtesy is not expensive and can pay big dividends<<

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

Lucy
Mon May 12 18:52:30 PDT 2008

Hi Vickie

You can use autofilter, there's a training course here:
http://office.microsoft.com/training/training.aspx?AssetID=RC011459671033

Lucy

--
Lucy Thomson
PowerPoint MVP
MOS Master Instructor
www.aneasiertomorrow.com.au


"Vickie" <Vickie@discussions.microsoft.com> wrote in message
news:69E50CEA-09C5-4C9A-8E77-DED5C89B754E@microsoft.com...
>I am trying to do a spreadsheet with age, sex and name on. I need to be
>able
> to pick out people from the spreadsheet that are for example, 20, male and
> called Bob. How do I do this? Thanks