3 posts tagged with excel by skypieces.
Displaying 1 through 3 of 3.

Excel: parsing seating chart, names - How best to do this?

I have an Excel Workbook with seating charts for our theatre. There are 4 pages, one for each production. Each page contains columns for 9 performance dates and rows for every seat in the theatre (about 300). I need to get this all into one readable sheet that I can use. Read on (tasty screenshots inside.). [more inside]
posted by skypieces on Aug 9, 2013 - 7 answers

Split one long column to multiple CSVs in Excel?

Excel: I have a long list of 2000 items addresses in a csv. That single column is all there is. Need to chop that list into 10 separate csv files of 20 items each. Is there a way to automate this? [more inside]
posted by skypieces on Jan 21, 2009 - 7 answers

Batch a list of ZIPs to time zones?

Need to find time zones for an extensive list of U.S. ZIP codes I have in Excel. (Not for Spam.) [more inside]
posted by skypieces on Dec 9, 2008 - 6 answers

Page: 1