Join 3,497 readers in helping fund MetaFilter (Hide)

6 posts tagged with sql and excel. (View popular tags)
Displaying 1 through 6 of 6. Subscribe:

Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie on Jun 19, 2014 - 17 answers

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]
posted by hrj on Aug 9, 2012 - 24 answers

How do I e-mail reports based on Excel documents?

Is there a nice way for me to run a report on an Excel spreadsheet and have that report e-mailed to me? I have a spreadsheet with dates of contracts expiring, I would like for it to shoot me an e-mail notifying me that I'm within 30 days of that contract expiring, that a new contract has been added and so on. [more inside]
posted by geoff. on Feb 20, 2009 - 7 answers

Working with Excel 95 files

How can I convert Excel 95 to at least '97 when uploaded to a server (iis) or... [more inside]
posted by Mick on May 2, 2006 - 7 answers

How to run a SQL Query on an Excel Spreadsheet

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark on Apr 7, 2006 - 6 answers

Page: 1