I'm an artist. Please help me find a day job that makes use of my bizarre love of spreadsheets.
[more inside]
posted by HeroZero
on May 15, 2011 -
8 answers
In Excel 2007 can I use data in a column on one spreadsheet to automatically change the name of another spreadsheet in the same workbook?
[more inside]
posted by Lentrohamsanin
on May 10, 2011 -
2 answers
Excel question: How can I tally by quarter when all I have are dates? Bonus challenge details inside.
[more inside]
posted by unannihilated
on May 9, 2011 -
5 answers
How do I create a macro in Excel that copies the contents of the cell two cells to the target's right and appends the contents to the end of the target cell? Both cells contain alphanumeric strings.
[more inside]
posted by geoffr
on May 3, 2011 -
7 answers
Excel-macro filter / this-must-be-possible filter: copy and paste a cell (say, A2) into Google Maps, hit submit, then copy and paste the first phone number into an empty cell (say, A10). How to make it work?
[more inside]
posted by chrisinseoul
on Apr 18, 2011 -
9 answers
How do I get Excel 2007 default to using column headers when I'm sorting?
[more inside]
posted by Dolley
on Apr 12, 2011 -
8 answers
Excel 2010-
I need to highlight both the row and the column of the cell that is currently selected in my enormous spreadsheet. Can you help me accomplish this?
posted by Irontom
on Mar 28, 2011 -
5 answers
Excel Question! I have two dates on my spreadsheet. How can I accurately determine (retrieve) the time remaining on a warranty date.
[more inside]
posted by TeachTheDead
on Mar 25, 2011 -
9 answers
Excel Filter: I have a long list of file names in numerical order in an Excel spreadsheet. I need to know what numbers are missing, so I can track down the related files. Is there a quick and (relatively) painless way of doing this without having to sift through all the numbers manually?
posted by Philby
on Mar 24, 2011 -
5 answers
MS Excel: All of my subjects took two tests and Scores 1 & 2 are in one sheet. Some of my subjects took an additional two tests, and Scores 3 & 4 are in another sheet. How can I merge the two sheets and align the rows so that each subject has all four scores in individual cells in a single row?
[more inside]
posted by oceanmorning
on Mar 24, 2011 -
6 answers
Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is
the one. Thanks!
posted by The Dutchman
on Mar 19, 2011 -
7 answers
There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle
on Mar 17, 2011 -
6 answers
How can I create a web-based table of contents that links to specific places within a diverse collection of documents?
[more inside]
posted by kirkaracha
on Mar 17, 2011 -
4 answers
Is there a quick and easy SAAS program I can use that replicates the functionality of MS Excel pivottables but on the web?
[more inside]
posted by jourman2
on Mar 14, 2011 -
6 answers
My conditional formatting in Excel 2007 is at war with itself. Help me emerge the victor.
[more inside]
posted by jph
on Mar 8, 2011 -
11 answers
ExcelFilter: I have Worksheet1 and Worksheet2. Both worksheets contain PersonName on the X-axis, ClassName on the Y-axis. I need to run some comparison between the two. Thinking of doing this on a 3rd worksheet. Here's where it gets tricky:
1. There are several thousand PersonNames.
2. There are about 100 CourseNames.
3. There is volatility in the PersonNames and CourseNames; they will be constantly changing, especially, the PersonNames.
[more inside]
posted by demagogue
on Feb 15, 2011 -
5 answers
Microsoft Excel 2003 Question: Can I manually set the Page Breaks in Page Break Preview, and THEN print the document so that each manually set page will fill the entire printed sheet of paper?
[more inside]
posted by ThePinkSuperhero
on Feb 1, 2011 -
3 answers
Is there any way to save a query in MS Office 2011's Query Builder that isn't tied to a specific spreadsheet?
[more inside]
posted by mph
on Feb 1, 2011 -
0 answers
What would be the best technology to port simple Excel-based applications to the web?
[more inside]
posted by elgilito
on Jan 29, 2011 -
11 answers
Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet?
[more inside]
posted by DrtyBlvd
on Jan 28, 2011 -
7 answers
If I don't figure out a solution, I may be doomed to hours upon hours of copying and pasting in Excel. My brain is crying out in pain for a solution, but I've never encountered this issue before. I need to transform sheet names into a variable on the sheet they represent. I'll try to explain this better inside.
[more inside]
posted by SpicyMustard
on Jan 27, 2011 -
14 answers
How do I combine two columns of text in Excel but maintain the formatting (italics and superscript) of the original cells?
[more inside]
posted by _cave
on Jan 24, 2011 -
3 answers
Excel question: Is there any way to have multi-word options (without underscores) in a drop-down list that will be used as a condition for a second drop-down list?
[more inside]
posted by Awkward Philip
on Jan 21, 2011 -
2 answers
In Excel 2011 for Mac, everything slows to a crawl if I cut or copy a large number of cells. Is there any way to fix this? If not, is there a different spreadsheet program that could do this quickly?
[more inside]
posted by eisenkr
on Jan 20, 2011 -
14 answers
What's the best way to edit a spreadsheet on my PC from across the room, using a Droid over Bluetooth (not WiFi)?
[more inside]
posted by Alabaster
on Jan 13, 2011 -
3 answers
I have an excel sheet with the past ten years' worth of donors for a PAC. Currently Column A is a donor and Column B is a donation. Some of these donors have donated multiple times, so their names come up several times on column A. I want to set up the spreadsheet to automatically look for matching names, and then add up the amounts in column B and give me a total in column C. How to do please.
posted by nushustu
on Jan 12, 2011 -
8 answers
In Excel (or Google Docs) is there away to divide the value in a cell by the number of cells selected? So if I have a value of x and I then highlight 10 cells, each of the 10 cells would show x divided by 10. As I select less cells, the value in each cell increases because x is being divided by less. The main reason I want to do this is to show how much I'd need to save per month to reach a specific total.
posted by cubedweller
on Jan 10, 2011 -
5 answers
Help with Excel! Is it possible to send specific information from one worksheet to another worksheet automatically?
[more inside]
posted by Kutsuwamushi
on Jan 4, 2011 -
9 answers
Excel question. Is there a way to determine a list of all possible values from a list that add up to a given total?
[more inside]
posted by xedrik
on Dec 14, 2010 -
4 answers
Excel help: I want to multiply two numbers, then subtract a percentage from that number, and arrive at a fourth number.
[more inside]
posted by Cool Papa Bell
on Dec 8, 2010 -
6 answers
Excel 2007 Filter: I need to convert a text file to XML. I have an existing XML file that has the correct schema, but no functional xsd file. How do I get the schema from the old file to map to the data in the new text file?
[more inside]
posted by ashirys
on Dec 2, 2010 -
1 answer
So I am stuck at work with Excel 97. I am trying to do something that seems simple enough in my head but just isn't.
Basically, I have a workbook filled with a bunch of worksheets. In some of those worksheets, I would a list of documents in a given folder with hyperlinks to those documents. I've managed to sort out a way to create a list of documents in a folder which updates each time the whole book is opened, but I really, really want that hyperlinked capability. More inside.
[more inside]
posted by neksys
on Nov 30, 2010 -
1 answer
