Go Back   Computer Juice > Computer Software > Office Suites & Applications
Register Members New Posts Donate Unanswered Posts Site Spy Search


Reply
 
Thread Tools
  #1  
Old 08-04-2008, 10:11 AM
HistoryGirl's Avatar
CJ Donator
 
HistoryGirl is offline
 
Join Date: Sep 2007
Last Online: 21-08-2008 03:31 PM
Posts: 259
iTrader: (0)
HistoryGirl is on a distinguished road
Default Excel question

For my uni dissertation, I'm creating a database of Beaker burials in Kent and Wiltshire. What I would like to know is there a way in the county column of selecting one or another, rather than having all the burials visible.

That's not very clear, basically I want to be able to select either those from Kent or those from Wiltshire is that possible?

I'm fairly certain it is, it's just been a while (about two years)since I've used excel.

Any help would be great, cos this is due in three weeks time.
__________________
Euro Championships tip = Spain & Torres
Make Poverty History
Control Arms Campaign
Water Aid
Amnesty International
__________________

My System: HistoryGirl

CPU(s):
Intel Core Duo T7300
Motherboard:
RAM:
2GB
Graphics Card(s):
nVida GeForce 8600M GS 256MB
Sound Card:
RealTek High Definition Audio
Hard Drive(s):
160GB SATA
Optical Drive(s):
HL-DT-ST DVDRAM GSA-T20 ATA
Case / PSU:
Cooling:
Network / Internet:
Intel (R) Wireless Wifi Link 4965AGN
Monitor(s):
15.4 WXGA Display
Operating System(s):
Windows Vista Ultimate

Want your system info in your signature?
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #2  
Old 08-04-2008, 03:09 PM
spot's Avatar
spot  Wales
CJ Donator
Intel Nvidia
spot is offline
 
Join Date: Feb 2008
Last Online: 03-09-2008 11:12 AM
Posts: 532
iTrader: (0)
spot is on a distinguished roadspot is on a distinguished road
Default Excel question

It's what the data filter's for.

If your county column contains just "KENT" or "WILTSHIRE" then it's a simple selection. Find the filter icon - it looks like a funnel I think - and you'll get a pull-down button at the top of each column (there's a form-filling alternative way of doing it too). Click the selector and there'll be two entries,
"KENT" and "WILTSHIRE". Click a county and all the other rows in the spreadsheet will disappear. It terrifies newbies, they think they've lost their data.

The form-filling alternative allows you to say "somewhere in that field contains KENT" in case your county field has more varied content (like a grod reference or a postcode or a survey height as well as the county).

Either of those answers can be attached to a user-defined button you can put into the spreadsheet (or on an existing button toolbar) to click between the two views.

If you can't do it with those hints tell us and someone will put a screendump picture of where to find the right bits but you'll have to say which version of Excel you're using.
__________________

My System: Tim

CPU(s):
Athlon 64 3500+
Motherboard:
Asus A8N-VM CSM
RAM:
Corsair PC3200 CL2 DDR-400 2GB
Graphics Card(s):
nVidia Geforce 6600 512MB
Sound Card:
Cherry RS 6000 M keyboard
Hard Drive(s):
Barracuda.7+ 2x200GB 58MB/s sustained
Optical Drive(s):
Samsung DVD-ROM TS-H352
Case / PSU:
Thermaltake Soprano
Cooling:
Stock
Network / Internet:
Telewest 2x20Mb/sec
Monitor(s):
SXGA flat panel
Operating System(s):
Slackware (2.6.24.3) (Fluxbox) (bash)

Want your system info in your signature?
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote

Please support this forum, donate towards our running costs.


Reply


Thread Tools

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word/Excel, quick question ashmehta Office Suites & Applications 6 22-05-2008 04:56 PM
Excel Question prawleprovi Office Suites & Applications 3 06-05-2008 04:52 PM
Excel Formula Help Jonathon28 Office Suites & Applications 6 22-02-2008 02:36 PM
Excel help Dj Ram Office Suites & Applications 2 19-02-2008 05:22 PM
Excel Help required juls Office Suites & Applications 1 09-10-2007 12:53 PM


Copyright ©2006 - 2008 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2008 Jelsoft Enterprises Ltd. SEO by vBSEO ©2008, Crawlability, Inc.

Page copy protected against web site content infringement by Copyscape