Is there a way to preserve grand total sorting in an Excel Pivot table when I've got a top 5 value filter on one of the columns? [more inside]
posted by undercoverhuwaaah
on Sep 3, 2010 -
Help me make a smooth transition into a new job in finance. I need to brush up on technical skills, most likely via excel. [more inside]
posted by Hurst
on Aug 18, 2010 -
Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros. [more inside]
posted by mbarryf
on Aug 11, 2010 -
help me parse this range of data using excel, by number of events per time span... [more inside]
posted by chasles
on Aug 4, 2010 -
iPhoneAppFilter: I have an Excel document on my home computer that I would like to be able to open and edit on my iPhone while I'm out and about, on an ongoing basis. The catch: app needs to be able to handle "index" and "match" functions. Without this functionality, the app would be useless to me. List of previous disappointments: DropBox (can't edit), QuickOffice (interfaces with DropBox but can't do index/match functions), Calc Lite (can't open document). I have zero programming skills and not that much more cash. Is my dream app (or combination of apps) out there?
posted by shortskirtlongjacket
on Aug 2, 2010 -
PowerpointN00Bfilter: How do I use the graphing functions in PP and Excel to simply display 2 columns showing two different values of x% of something? [more inside]
posted by broadway bill
on Aug 1, 2010 -
Excelfilter: This may be a long shot, but..... Is there a quick way of formatting a table to group like records under a single heading? [more inside]
posted by Kurichina
on Jul 29, 2010 -
ExcelFilter: Help me avoid scientific notation when importing a .csv file. I face the same problem faced by "Mark" in this article
. Is there a solution to this problem that does not require changing the file extension? I am using Excel 2003.
posted by bgrebs
on Jul 22, 2010 -
Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses.
Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API.
This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program?
Thanks in advance.
posted by watercarrier
on Jul 21, 2010 -
How do I chart my life? I'm using an Android App to input information against a date/time such as weight/mood/alertness/alcohol units etc. How can I easily view all this data on a big chart so I can see what relationships might exist? [more inside]
posted by razzman
on Jul 19, 2010 -
YTD total based on sum of last number in another row that has a value?
I need to sum up the values in one row based on the matching row below it. For example, if I have a target of $1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul.
I have tried a couple of variations on COUNT, INDEX and OFFSET.
Example is here: http://malcommc.com/ytd.xls
I am using Excel 2003
posted by malcommc
on Jul 12, 2010 -
I would like to take the information from this Wikipedia
page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
posted by jontyjago
on Jul 10, 2010 -
I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
posted by angelaas525
on Jul 9, 2010 -
Excel guru filter: I want to change this formula every week, and have the change cascade across 20 tabs of independent data. [more inside]
posted by deludingmyself
on Jul 3, 2010 -
Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
posted by notcostello
on Jun 29, 2010 -
I have an excel 2007 spreadsheet that has 4,000 rows and 6 columns of information. Need help merging some of the rows together..... [more inside]
posted by bleucube
on Jun 23, 2010 -
I have lists, in Excel spreadsheets, that contain perhaps 500 rows of data in three columns: Date, Time and Stock Ticker Symbol. I need a method to correlate those three things with unusual stock activity.
In other words, if column 1 is March 10, 2010, and column 2 is 10 a.m., and column three is INTC, I need to know if something unusual happened - high volume or big price movement - for INTC around 10 a.m. March 10.
Anyone know a program that'll do this?
posted by Flunoid
on Jun 17, 2010 -
I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
posted by anderjen
on Jun 10, 2010 -
Is there a relatively complete movie database in csv or other Excel-friendly formats? [more inside]
posted by AmitinLA
on May 31, 2010 -
Excelfilter: Okay, I'm confident that this can be done in Excel, but I don't know how. Basically, I have a set of samples for which a value (size) was measured at various days. I need some formulas to tell me when the first and last values were measured and what those values were (for each sample). [more inside]
posted by kisch mokusch
on May 26, 2010 -
Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
posted by randomname25
on May 19, 2010 -
Excel Assist/I don't believe I couldn't figure this one out: I have a table with unique text values. How can I have it act the same way as a pivot table? Sample inside. [more inside]
posted by yoyoceramic
on May 17, 2010 -
How do I obtain a list of all words associated with a list of word roots / stems? [more inside]
posted by hooves
on May 13, 2010 -
Is to possible to map several addresses from an excel spreadsheet on Google earth, Google maps, etc. using a macro? [more inside]
posted by jefficator
on May 13, 2010 -
Can you reccomend me a good Excel 2007 Book?
I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel.
Can anyone reccomend a good book to get that would include information relative to that?
posted by sockpim
on May 5, 2010 -
Clipboard and/or Excel question: How can I assign a function key to do a Ctrl+V paste? [more inside]
posted by crapmatic
on Apr 21, 2010 -
MS Excel-filter: I want to be able to search for the second occurrence of a word in column A and then pull the corresponding value from column B. More inside. [more inside]
posted by prunes
on Apr 16, 2010 -
I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out. [more inside]
posted by digitalprimate
on Apr 13, 2010 -
Excel help. In column A I have several thousand numbers. In column B I have several thousand more numbers, some of which are in column A. I would like column C to contain the numbers from column A that are NOT in column B. I would also like column D to contain the numbers from column B that are NOT in column A.
posted by BigVACub
on Apr 8, 2010 -
I'm making an archival database (in Excel) with about 10,000 rows and 6-7 columns for each row. I'm doing this so the information will be easy to cross-reference and search. I've never done anything like this before and am looking for books, blogs, etc. for tips, suggestions, and anything that will make my life and this project easier.
posted by melodykramer
on Mar 29, 2010 -
I need to organize a spreadsheet of log files into specific columns. The spreadsheet is a converted text column, each log file parses things differently, so column 'a' on one row can be userid, while column 'd' on row is the userid.
I want to organize this spreadsheet, so that column a is userid for all logs. is there a specific excel formula or macro i should use, i was thinking:
if cell contains userid, move to column 'x'. just not sure how to do this.
posted by fozzie33
on Mar 29, 2010 -
Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card. [more inside]
posted by beammeup4
on Mar 23, 2010 -
I have: An excel spreadsheet with a bunch of emails. I need: A self-updating text string that can be copy-pasted into an email TO: Field. I know about C1&","&D1 but is there a way for the list to be automatically updated when I or subtract an email, without specifically having to tell the formula to look in the newly added row? [more inside]
posted by amethysts
on Mar 23, 2010 -