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!
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.
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.
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.
Nope.
sigh
I'm working on converting the spreadsheet into Notes, which I DO have.
Can one run SQL queries against Excel data in Excel?
Theoretically, you could write a SQL parser/interpreter in VBA, but no.
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.
