I have an xls file I got from a survey I created on Google docs. Now I want to make it pretty without copy-pasting every bloody cell into an Indesign document… [more inside]
posted by monocultured on May 17, 2009 - 7 answers

How do I convert a large raster image into a table for analysis and manipulation? [more inside]
posted by agentofselection on Dec 14, 2008 - 9 answers

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]
posted by niles on Oct 20, 2008 - 7 answers

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

How can I make readable Word tables out of a large Excel spreadsheet? [more inside]
posted by lunchbox on Jul 6, 2008 - 7 answers

Someone asked me if I could use Excel to take a table of information and put it into a new table randomly. Without thinking about it too hard I said "Yeah, I bet I could do that." Turns out I spoke too soon. [more inside]
posted by qldaddy on May 13, 2008 - 7 answers

I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients. [more inside]
posted by dance on Nov 5, 2007 - 2 answers

Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]
posted by bwilms on Jun 9, 2006 - 10 answers

Help me with creating two bar charts from two columns in one pivot table, please? [more inside]
posted by dantodd on Mar 30, 2006 - 4 answers