Jayne: Anybody remember her comin' at me with a butcher's knife? Wash: Wacky fun.
'Objects In Space'
Buffistechnology 2: You Made Her So She Growls?
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
§ ita § - Feb 27, 2006 8:05:25 am PST #7221 of 10003
Well not canonically, no, but this is transformative fiction.
Theodosia - Feb 27, 2006 8:27:41 am PST #7222 of 10003
'we all walk this earth feeling we are frauds. The trick is to be grateful and hope the caper doesn't end any time soon"
I know how to do AutoFilter in Excel, which is good when I want to look at a single value in a spreadsheet list. But what I want is a list of unique values (names of counties) that I can print out! I can copy it down by hand if I click on the filter widget, which is clumsy and slow, and also, since I'm reviewing who gets what Texas counties, I can have a list of 50 or more to copy out by hand.
Is there a better way? I tried typing "find unique values in a column" in the Excel Help, but all it did is tell me about AutoFilter, which I pretty much know about already. I don't need to go into Criteria, since that looks like something you use to FIND things, not get a handy list of the values you want to FIND.
Yours Truly, Tearing At The Hairroots and Cursing Bill Gates
tommyrot - Feb 27, 2006 8:41:03 am PST #7223 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
So you have a whole bunch of county 'A', a whole bunch of county 'C', etc. and you just want a list of 'A', 'C', etc?
If that's it, sort the counties. Then select the counties, along with the header for the counties and go to Data / Subtotal, and then select "at each change in county" then click OK. Then collaps all the sections (click on the '-').
I think there must be a better way, as this is designed for subtotals, but it might get you what you want.
eta: This is very easy in a database such as Access.
Theodosia - Feb 27, 2006 8:52:57 am PST #7224 of 10003
'we all walk this earth feeling we are frauds. The trick is to be grateful and hope the caper doesn't end any time soon"
sigh So far I've locked up Excel trying to do that. I may have a bit too many rows... though that was my problem in the first place.
Theodosia - Feb 27, 2006 8:54:06 am PST #7225 of 10003
'we all walk this earth feeling we are frauds. The trick is to be grateful and hope the caper doesn't end any time soon"
Texas has far too many counties, by the way. Especially because a lot of them seem to have about 150 students in them. To a girl from NJ, which has a sensible number of counties this seems very foreign indeed.
tommyrot - Feb 27, 2006 8:55:26 am PST #7226 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Do you have Access?
Theodosia - Feb 27, 2006 9:40:39 am PST #7227 of 10003
'we all walk this earth feeling we are frauds. The trick is to be grateful and hope the caper doesn't end any time soon"
Nope. sigh I'm working on converting the spreadsheet into Notes, which I DO have.
tommyrot - Feb 27, 2006 9:43:20 am PST #7228 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Can one run SQL queries against Excel data in Excel?
Tom Scola - Feb 27, 2006 9:47:09 am PST #7229 of 10003
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Theoretically, you could write a SQL parser/interpreter in VBA, but no.
tommyrot - Feb 27, 2006 9:51:33 am PST #7230 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Yeah, I just discovered that you can run queries against external data (in SQL Server), but that's it.
I think a lot of people use spreadsheets (especially Excel) for data that a database would be more suitable for. Which is understandable, as I think there are a lot more people with spreadsheet experiance than database experience.