883 posts tagged with excel.
Displaying 251 through 300 of 883. Subscribe:

Show all formulas.

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

Need help with (presumably) conditional formatting issue in excel

How do I use two cells to conditionally target a different cell? [more inside]
posted by FireStyle on May 11, 2011 - 3 answers

Using Table data to automatically (re)name worksheets in Excel 2007?

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 Wizardry Needed

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

Copying contents of cells in Excel

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

How Can I Make This Chart in Excel 2010?

Can you help me change the color on part of a chart in Excel 2010? [more inside]
posted by Bugbread on Apr 24, 2011 - 4 answers

There's data just waiting to be scraped....

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

Please default to column headers, Excel.

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

Help my theoretical trains not crash.

I have a rather specific excel question. Please help me. [more inside]
posted by millipede on Apr 6, 2011 - 9 answers

Please help me with this encoding issue!

Please help me with this encoding issue! Fun with Python, Unicode, Excel, and the IPA. [more inside]
posted by ootandaboot on Apr 2, 2011 - 13 answers

Excel 2010: How to Highlight Row and Column of Selected Cell

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 Vs. Time Left

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

I Know What I Know.. But How Do I Know What I Don't Know?

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

The Power of Excel Compels You!

Help me pass a test using Excel (special snowflake banking industry questions inside). [more inside]
posted by digitalprimate on Mar 24, 2011 - 8 answers

How to line up data based on a single identifier?

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

Good help forum for Office 2010?

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

stymied by excel

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 link to specific places in a variety of documents?

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

EXCELerate My Workflow

Excel 2011: How do I create custom styles for Conditional Formatting? [more inside]
posted by 47triple2 on Mar 15, 2011 - 2 answers

colour me worried

Help! My painstaking hours in Excel won't transfer to Powerpoint! [more inside]
posted by whalebreath on Mar 14, 2011 - 7 answers

My googles are failing me

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

I don't want to Excel, just get by...

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

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows?

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]
posted by bottlebrushtree on Mar 5, 2011 - 7 answers

How export list of sent emails?

Outlook filter: How can I export a list of sent emails to Excel? [more inside]
posted by LonnieK on Feb 17, 2011 - 3 answers

I love Excel... when I know what I'm doing

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

Excel 2003 Page Break/Print Area Q

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

How can I reuse a Query Builder query?

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

How to port Excel applications to the Web?

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

Spreadsheet Data Sorting

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

How to keep lists sorted both horizontally and vertically?

Sorting and keeping track of my research: is Excel the best solution? [more inside]
posted by pipti on Jan 27, 2011 - 13 answers

Please help me out of a Microsoft Excel morass

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

Fancy concatenate in Excel?

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 multi-word list items possible?

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

How to copy and paste quickly in Excel 2011 for Mac.

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

Making a dumb spreadsheet smart

I'm having trouble solving a problem in Google Spreadsheet. [more inside]
posted by downing street memo on Jan 14, 2011 - 3 answers

Edit a master spreadsheet remotely with a Droid over Bluetooth?

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

Excel question

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

Can excel save me money?

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

How to automatically update one Excel worksheet from another?

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 sort for relative placement

I'm trying to implement a sorting algorithm in Excel known as "relative placement." Here's the setup: [more inside]
posted by philosophygeek on Dec 17, 2010 - 2 answers

Excel math puzzle

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

How can I find common words in two lists?

How can I find common words in two (or more) lists? [more inside]
posted by pantufla on Dec 13, 2010 - 9 answers

Excel changes cell colors on its own!

Why does moving a cell or cells in Excel change the background color in the cell it was moved from??? [more inside]
posted by Jackie_Treehorn on Dec 9, 2010 - 6 answers

Help me calculate a percentage contribution to a final total

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

How can I compare the text in two excel cells for common terms?

How can I compare the text in two excel cells for common terms? [more inside]
posted by pantufla on Dec 6, 2010 - 5 answers

How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel? [more inside]
posted by teg on Dec 6, 2010 - 14 answers

Excelfilter: XML Mapping gone wrong

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

How to merge & combine .pdf to Excel pages

How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]
posted by ~Sushma~ on Nov 30, 2010 - 5 answers

Outputting a hyperlinked list of documents in a folder with relative filepaths in Excel 97

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

Excel 2007 text to column help

Excel 2007 text to column help. [more inside]
posted by Ezrie on Nov 30, 2010 - 19 answers

Page: 1 2 3 4 5 6 7 8 9 ... 18