Excel Purgatory - Help!
How do I take an average of two individual data items within in a field in a Pivot Table? (More Inside) [more inside]
posted by JPD
on Feb 10, 2005 -
I need a simple hand held scanner that will scan text and allow the scanned text to be converted to something that can be imported into Excel or a database as text. Any suggestions? [more inside]
posted by spicynuts
on Feb 8, 2005 -
Embedding linked Excel 2003 worksheets in a Word 2003 document for portability is giving me pains! [mi!] [more inside]
posted by hominid211
on Feb 4, 2005 -
Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking. [more inside]
posted by cyniczny
on Feb 1, 2005 -
Is there a plug-in or macro for Excel v.X or Excel 2004 for Macintosh that adds PivotChart (from Excel 2003 for Windows) functionality or compatibility?
posted by AlexReynolds
on Jan 13, 2005 -
EXCEL FILTER: I have an entire column of 12 digit numbers with dashes (X-XXXX-XXXXX-X-X) and I need to delete the first five digits (and two dashes) so I can sort the numbers starting with the sixth digit. Is this possible? (more inside) [more inside]
posted by Slack-a-gogo
on Jan 7, 2005 -
I have an Excel document listing dates times and other information. I'd like to import this "calendar" to iCal but cannot figure out to get the information imported properly. I found this tool
, but couldn't get it to work. I also found this application, iCal Maker
but it doesn't seem to work either. Anyone have an idea on how to import a bunch of events listed in an Excel document to iCal? [More Inside] [more inside]
posted by pwb503
on Dec 19, 2004 -
How do I change the matrix of the legend in an Excel chart? I have 1x6, and I want 3x2.
posted by trharlan
on Nov 19, 2004 -
: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast? [=Text(MI)] [more inside]
posted by mwhybark
on Sep 29, 2004 -
Excel Question - Is there a way in Excel to evaluate whether a cell contains text that is in all caps as opposed to proper (first letter) caps. I know I can force cells into Upper or Proper, but I don't want to do that, i just want to flag and sort them.
posted by willnot
on Sep 23, 2004 -
How do I format cells in EXCEL to accept numeric values in the form: -26:32 (or +26:32 ... that is, mm.ss but including the pos/neg sign)? I'm trying to compile a simply list of Messier Objects (astronomy) and can't figure out how to include declinations.
posted by RavinDave
on Sep 14, 2004 -
I have a mountain of data to move from dozens of Excel spreadsheets into an Access database. The database is an existing one and sort-of documented. How do I go about doing this? I’m very comfortable with Excel, but not at all with Access---I’ve never used it before. How do I push Excel data into Access records? Are there any web resources I could use? Any books I should buy?
posted by bonehead
on Aug 19, 2004 -
I need to use Excel's FIND function to locate open-parentheses, but since parentheses are part of the syntax of the function itself, it's choking. How can I escape the character to make this work?
posted by scarabic
on Aug 6, 2004 -
Microsoft Excel 2000 v 9.0 - is there some way to stop excel from automatically turning email addresses into hyperlinks? Not just turning off the 'blue and underlined' format but actually not making them links. I've done it before in other versions of excel but I can't find a way to do it in this version. Thanks!
posted by anastasiav
on Jul 16, 2004 -
ExcelFilter: I've got a specific problem in mind [inside for the curious/helpful], but more importantly I'm looking for an advanced tutorial for excel. I'm looking to go from someone who is confident with excel to being a full-on pro. Books are ok, but I'd prefer internet (i.e. free) resources. I am using Office v.X for Mac, but I think most techniques will translate pretty well across platforms. I'm looking for things like recursive formulas, modeling theory, little-known tools/techniques, pivot tables, etc. [more inside]
posted by rorycberger
on Jul 15, 2004 -
I'm looking for a good, but very basic Excel tutorial. I'm somewhat familar with computers at large, but suddenly faced with an office productivity application my eyes are rolling up in my head and I'm drooling liberally. [more inside]
posted by elwoodwiles
on Jul 10, 2004 -
: I have an Excel spreadsheet where one column is filled with dates — but the dates aren't showing up properly in the spreadsheet. Instead of looking like a date, they are flat numbers (02/29/2004 is rendered "36584" in the display) — even though the proper date is revealed in the FORMULA BAR as I select each cell. I've set the text type to DATE in the FORMAT dialog... I've even tried setting the text type to PLAIN TEXT. No go. Strangely, the numbers increment with the date (03/07/2004 is "36591"), so I'm guessing there's some equation going on. Suggestions on getting the dates to render properly would be appreciated.
posted by silusGROK
on Jun 25, 2004 -
Is there a way to cut'n'paste charts from Excel into Word, without generating huge Word files? I've tried varieties of paste, 'paste special,' and so on, and I can't figure out why an Excel file of charts that's several hundred KB, always turns into a Word file that's at least several MB. I guess I'm missing something obvious, but have no idea what it is.
posted by carter
on Jun 24, 2004 -
I've recently realized that Crystal Ball
is incredibly powerful and cool. Unfortunately, it isn't available on a mac. Anybody know of equivalent software/plugins for the Mac version of Excel?
posted by rorycberger
on Jun 18, 2004 -
! How do I keep Excel from hotlinking URLs as I paste them into cells? I use spreadsheets to store, sort, and transform lots of URLs. But Excel seems to think that anything beginning with "http://" is something I want blue and underlined and hotlinked for easy clicking. It doesn't happen right away, only once I leave the cell does it become a hot link. I'd like Excel to just leave my text strings alone. I don't want to launch a browser window every time I click in a cell that contains a URL. And I'm tired of doing the right-click-remove-hyperlink thing every single time. Formatting the column as plain text before dropping in the URL *doesn't* work. As soon as you paste a URL into a cell, Excel wakes up, decides to "preserve the formatting" of your pasted text, and voila! A nice blue hot link. Is there a preference I can un-check for this?
Sorry if this is a stupid one. I can't find anything in the help documentation or via Google that solves my stupid problem.
posted by scarabic
on May 28, 2004 -
How much should an Advanced Excel (PivotTable, lookups, etc.) hombre in Manhattan be getting paid? I've been temping in this hole of an office for a few months and almost all spreadsheetery has become my responsibility. I think some sort of raise is in order, but I'm not sure what my target should be.
posted by skryche
on May 27, 2004 -
Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.
One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.
The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.
Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted by ajpresto
on May 11, 2004 -
Hit "save" instead of "save as" in Excel... big mistake. The Undo control is 'greyed out' and googling doesn't give an answer, or I'm using the wrong words. Does anyone know if I can recover what I changed?
posted by chaz
on May 10, 2004 -
Using Excel 2001 for Mac, is there any way to set up a column that can autocomplete using data from another column? If not, is there something that can handle this sort of thing?
posted by the biscuit man
on Apr 25, 2004 -
I need to create some charts (as in bar-, pie-, etc.) for a presentation. I have used Excel (easy but boring), Illustrator and Freehand (slightly more complicated and exciting) for this in the past, but want to expand my repertoire. Are there any really snazzy looking, easy to use charting apps for XP? [more inside]
posted by signal
on Mar 24, 2004 -
MS Excel appends a 1 to the name of every file I open. How do I get rid of this? [more inside] [more inside]
posted by trillion
on Feb 20, 2004 -
Invoicing with MS Excel--squeezing relational database features out [MI]
posted by adamrice
on Feb 17, 2004 -
Dumb Excel question: How do you add rows of cells at the top of a sheet that do not scroll? We've tried Googling, we've tried the Excel help, we've tried poking around at every function that looks obvious, and a few that didn't...
posted by adamgreenfield
on Jan 23, 2004 -
I'm working with an alphabetical list of email addresses in Excel, approx. 8500 addresses long. Is there any quick way to remove duplicates outside of manually scrolling through and deleting them by hand?
posted by rocketman
on Jan 7, 2004 -