Excel question: I'm looking to pull a months and years worth of spreadsheet information to a summary report. The days work is saved as reportxxxxxx (month/day/year) [more inside]
posted by brent
on Dec 27, 2006 -
MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]
posted by chrisamiller
on Dec 27, 2006 -
I'm doing a code review and I'm keeping track of my findngs on an Excel spreadsheet. I need to generate reports that show vital details about the source code file being reviewed. Unfortunatley, as far as I can tell, MS Word 2003 generates one Word doc that has all oft he merged content in one file. How do I get it to create separate documents? [more inside]
posted by apark
on Nov 17, 2006 -
My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to.
posted by patrickje
on Nov 16, 2006 -
I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5.
I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea?
(I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted by stonefruit
on Nov 9, 2006 -
Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted by ao4047
on Nov 6, 2006 -
I have a large excel spreadsheet that contains various html tags, mainly bold and anchor tags (in upper case and lower case). How can i automagically remove them? [more inside]
posted by anonaccount
on Oct 27, 2006 -
Excel wizards: is it possible to create a temperature conversion calculator (Celsius, Fahrenheit, and Kelvin) using only 3 cells for the interface
? I have the conversions
and know how to do conditional formulas
, but what tricks would be involved in having each cell handle both output and potential input?
posted by Tubes
on Oct 24, 2006 -
Excel: I am trying to create a line graph of last year's workload versus this year's workload. Problem is, I don't have consistent data and my graphs have numerous gaps between data points. How can I best fill these gaps? [more inside]
posted by Ziggy Zaga
on Oct 15, 2006 -
Excel help please: Is there a keystroke for Insert->Name->Define? Can I make one? How? I use this a ton in my work.
posted by eatdonuts
on Sep 25, 2006 -
I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
posted by batcrazy
on Sep 21, 2006 -
I've created a button in Excel 2002 that runs some VBA when clicked. Works great. I've emailed the spreadsheet home and opened it with Excel 97 and clicking does nothing.
When I run the subroutine from VBA editor, it works fine. So, what gives? Why won't this work in Excel 97 and what can I change so that it will run in Excel 97 and beyond?
I've pasted the subroutine into the Extended box. Oh, and I'm really an infant with this, so please try and communicate on that level. [more inside]
posted by kc0dxh
on Sep 8, 2006 -
There's a little pop-up menu beside a cell in Excel. I cannot click it open to see what it's trying to offer, and I cannot "clear all contents" in that cell to get rid of it! [more inside]
posted by umlaut
on Sep 6, 2006 -
OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
posted by Marnie
on Aug 22, 2006 -
I run a computer service. I have an issue that is a bit outside the bounds. I have a client who has been using an Excel spreadsheet to track his portfolio. It is pre-formatted for him to enter data and the formulas are all there.
Just recently, it started calculating some things incorrectly.
The person who originally set it up just passed away earlier this year.
We need an Excel expert that can look at the file and don't know where to begin to find one. Checked the local community college but no dice. All ideas or pointers are appreciated.
posted by titans13
on Aug 17, 2006 -
Excel / VBA help needed: moving data from multiple columns to a 2-column format [more inside]
posted by blag
on Aug 17, 2006 -
It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this? [more inside]
posted by arimathea
on Aug 8, 2006 -
Way to automate string creation from values in an Excel spreadsheet? [more inside]
posted by mhaw
on Aug 5, 2006 -
Is there a way to break/uncover/crack/hack an Excel spreadsheet password? [more inside]
posted by jckll
on Jul 26, 2006 -
Excel Filter: I need to convert a wallop load of cells that are in decimal format to hours & minutes format. Please. More Inside. [more inside]
posted by kev23f
on Jul 21, 2006 -
Is it possible to stipulate that a Microsoft Excel file will always display a specific number format e.g. the Anglo-American decimal point, regardless of the local settings of the computer where it is viewed? [more inside]
posted by rogerh
on Jul 13, 2006 -
MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.
posted by bigmusic
on Jul 8, 2006 -
DataOrganizationFilter: I am looking for software that will allow my market research team to efficiently store and access information from PDF and Excel files. [more inside]
posted by drkrdglo
on Jun 28, 2006 -
Excel 2003 graph woes. My friend is looking to make a simple x:Date; y:Value chart but with one problem. [more inside]
posted by jedrek
on Jun 22, 2006 -
I have an Excel worksheet populated with data from columns A through IS. I’d like to hide columns but I am getting the following error: “Cannot shift objects off sheet.” Why? [more inside]
posted by phoenixc
on Jun 19, 2006 -
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 -
A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
posted by empyrean
on Jun 6, 2006 -
I would like to make a chart like this
to track my daily computer usage. Any ideas on how I could do this? Any free software you can recommend? Any way of doing it with Excel? [more inside]
posted by bubukaba
on Jun 1, 2006 -
I need help with an Excel formula. Warning: this may venture into the realms of calculus. Maybe. [more inside]
posted by thecjm
on May 21, 2006 -
Excelfilter: how do I compute a rolling seven-day average for something that happens at sporadic intervals? [more inside]
posted by jessamyn
on May 21, 2006 -
ExcelFilter: I need help creating a pie chart as a separate worksheet in Excel that counts how often values appear in a column and creates a pie graph based on that data. I'm stumped, I'm not using the right Google terms, and my company's help desk couldn't guide me through the process, either. (That sounds awkward, so I describe it more comprehensibly inside.) [more inside]
posted by WCityMike
on May 19, 2006 -