HTFC Forums

H.T.F.C.

How To Fix Computers





Go Back   HTFC Forums > Software Newsgroups > Microsoft Office

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 05-12-2008, 03:37 PM
Vickie
 
Posts: n/a
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 05-12-2008, 04:21 PM
JoAnn Paules
 
Posts: n/a
Default Re: filter information

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



Reply With Quote
  #3  
Old 05-12-2008, 05:04 PM
Bob Buckland ?:-\)
 
Posts: n/a
Default Re: filter information


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/new...t.public.excel

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



Reply With Quote
  #4  
Old 05-13-2008, 02:52 AM
Lucy Thomson
 
Posts: n/a
Default Re: filter information

Hi Vickie

You can use autofilter, there's a training course here:
http://office.microsoft.com/training...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



Reply With Quote
Sponsored Links
Fix your Windows Problems - FAST.
FREE Safe Scan Registry Check. Locate & Fix Errors in Minutes!
Reply


Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
System Information - "Can't Collect Information" microsvc Windows Vista 14 09-05-2008 05:49 AM
VS Filter Al H Windows XP 3 10-26-2007 11:29 AM
Polarizing Filter Ockham's Razor Digital Photo 9 04-30-2007 03:53 PM
ND filter embee Digital Photo 9 04-28-2007 02:33 AM
cap vs filter Mike Digital Photo 16 04-09-2007 04:01 PM


All times are GMT. The time now is 06:54 PM.


Powered by vBulletin® Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
© 2004 - 2007 Web-S-Sense Pty. Ltd. Usenet and forums posts © their respective authors.
Ad Management by RedTyger