Prev: Everything (icons, aol screen) is minaturized --- how to undo it?
Next: Word2003 merge with OE6
From: Vickie on 12 May 2008 10:37
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
From: JoAnn Paules on 12 May 2008 11:21
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(a)discussions.microsoft.com> wrote in message
news:69E50CEA-09C5-4C9A-8E77-DED5C89B754E(a)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


From: Bob Buckland ?:-) on 12 May 2008 12:04
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(a)discussions.microsoft.com> wrote in message news:69E50CEA-09C5-4C9A-8E77-DED5C89B754E(a)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



From: Lucy Thomson on 12 May 2008 21:52
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(a)discussions.microsoft.com> wrote in message
news:69E50CEA-09C5-4C9A-8E77-DED5C89B754E(a)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


 | 
Pages: 1
Prev: Everything (icons, aol screen) is minaturized --- how to undo it?
Next: Word2003 merge with OE6