Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets? [more inside]
posted by itsonreserve on Dec 23, 2009 - 7 answers

Why would Excel 2008 cause a lot of network traffic while typing in a cell? [more inside]
posted by lbergstr on Nov 27, 2009 - 10 answers

Another GD excel/csv filter [more inside]
posted by TheBones on Nov 20, 2009 - 3 answers

Please help me create an excel macro to hide rows given a certain criteria. [more inside]
posted by onich on Nov 17, 2009 - 9 answers

Any Excel whizzes out there? I'm having a problem that I just know is going to have a head-slappingly simple solution, but I still can't figure it out. [more inside]
posted by andrewcilento on Nov 10, 2009 - 8 answers

Excel question: I need a row number to automatically increment as I copy a formula horizontally across columns. Sample spreadsheet downloadable here, or viewable as a Google Doc here. Further details inside. [more inside]
posted by Conrad Cornelius o'Donald o'Dell on Nov 7, 2009 - 12 answers

How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas? [more inside]
posted by Bugbread on Oct 22, 2009 - 7 answers

I started a new internship, and I'm wondering if there is some way to automate copying the non-profit information from this website. [more inside]
posted by moonroof on Oct 21, 2009 - 6 answers

How can I force Excel 2007 to save as a single html file? [more inside]
posted by thisisnotbruce on Oct 20, 2009 - 3 answers

In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

Does anyone know how to remove the formatting (for lack of better expression) column borders that accompany text when I paste it from Excel to Word? I've checked both Word & Excel help to no avail, probably because I can't frame the question very well. Thanks.
posted by holdenjordahl on Sep 9, 2009 - 8 answers

Another crazy excel question- I can't promise this won't be my last one. [more inside]
posted by TheBones on Sep 2, 2009 - 8 answers

Excel: How can I decide which cell to apply to a formula, based on the runtime contents of another cell? [more inside]
posted by Flunkie on Aug 30, 2009 - 4 answers

I need to transpose a lot of data in Excel. How can I do it efficiently? [more inside]
posted by bobber on Aug 7, 2009 - 19 answers

Excel 2003 says I have macros in one workbook. I want to delete them, but Excel won't let me. NeoOffice (for the Mac) also won't let me. When I look for them using the Macro Dialog box or the VB editor, I can't find them. Can I delete these macros, or do I have a serious problem? [more inside]
posted by CancerMan on Jul 10, 2009 - 9 answers

Can anyone recommend a good template for tracking multiple savings account balances in Excel? [more inside]
posted by IanMorr on Jul 6, 2009 - 5 answers

How to determine how much I'm owed by someone who's not going to pay regularly ? (in Excel preferably). [more inside]
posted by southof40 on Jun 22, 2009 - 7 answers

Can I download only OpenOffice Writer? [more inside]
posted by ptsampras14 on Jun 18, 2009 - 4 answers

What is the best way to set up data and formulas in Excel 2007 to count the number of products that make up x% of sales volume? [more inside]
posted by Andy's Gross Wart on Jun 15, 2009 - 7 answers

I need an Excel conditional formatting formula for locating dups within a two-column row. [more inside]
posted by RavinDave on Jun 12, 2009 - 3 answers

Please recommend beginning MS Excel and Word classes (offline) in Los Angeles for a computer-antagonistic but somewhat -knowledgeable almost-senior. [more inside]
posted by tyrantkitty on May 22, 2009 - 3 answers

Excel n00b needs help with what ought to be a very simple custom formula. And yes, I have looked around on the interwebs for the answer. [more inside]
posted by wowbobwow on May 6, 2009 - 6 answers

I need to make a template for an in-print events calendar, and I'm not sure what the best way to approach this project is. Advice please! [more inside]
posted by soviet sleepover on May 5, 2009 - 2 answers

How to extract data automatically from a group of HTML pages to an Excel file or to a database? [more inside]
posted by elgilito on Apr 22, 2009 - 5 answers

So I have an array of data in Excel. Specifically, weekly repos outstanding (dollar amounts) since 2001. Is there any way to find monthly rate [(last date of month-first date of month)/first date of month] of change for it? What I have in mind is something like subtotals function except it shows rate of change rather than sum or average. Does anybody have any ideas? [more inside]
posted by Lucubrator on Apr 21, 2009 - 6 answers

What formulae do I need to cause Excel to highlight a cell on one worksheet if the data is found in a different worksheet? Formulae I have attempted (using named ranges) under the cut. [more inside]
posted by mccn on Apr 21, 2009 - 5 answers

Which one is right, Google or Excel? [more inside]
posted by JDHarper on Apr 2, 2009 - 22 answers

Need to get Excel to ROUND properly in a custom way, details inside... [more inside]
posted by emjay on Mar 30, 2009 - 8 answers

Excel-filter: Mysterious single-quotes that precede the data in each cell. How do I get rid of them? [more inside]
posted by ashirys on Mar 18, 2009 - 16 answers

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
posted by Akeem on Mar 12, 2009 - 3 answers

Excel-Fu Filter: I need to merge latitude and longitude values (in two columns) corresponding to a specific site from one worksheet to the corresponding site in another worksheet. [more inside]
posted by schyler523 on Mar 3, 2009 - 7 answers

How do I check for linearity? [more inside]
posted by ttyn on Feb 28, 2009 - 9 answers

Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
posted by guptaxpn on Feb 5, 2009 - 6 answers

I-don't-know-what-I'm-talking-about-filter: Excel 2003 VLOOKUP help, please! [more inside]
posted by dogmom on Feb 4, 2009 - 7 answers

Help me sort out this problem of ranking bracket winners... Thx in advance, hivemind. [more inside]
posted by mhh5 on Jan 22, 2009 - 7 answers

Excel: I have a long list of 2000 items addresses in a csv. That single column is all there is. Need to chop that list into 10 separate csv files of 20 items each. Is there a way to automate this? [more inside]
posted by skypieces on Jan 21, 2009 - 7 answers

Using Excel VBA, how to convert positive numbers to negative, and vice versa? [more inside]
posted by yezimary on Jan 7, 2009 - 16 answers

How can I have Excel generate a new column with the data I need using certain conditions and pulling data from a pivot table? [more inside]
posted by ttyn on Jan 6, 2009 - 5 answers

Automation Filter: How can I automate the insertion of data from a spreadsheet into a Word report template? [more inside]
posted by McBearclaw on Jan 6, 2009 - 8 answers

I need to generate the complete series of 5 digit numbers. The catch? Can only use even digits (0,2,4,6,8). I'd like to accomplish this in Excel, if possible.
posted by Rock Steady on Dec 12, 2008 - 28 answers

Need to find time zones for an extensive list of U.S. ZIP codes I have in Excel. (Not for Spam.) [more inside]
posted by skypieces on Dec 9, 2008 - 6 answers

YAEQ: How would I generate a chart in Excel 2007 that tracks, not towards a goal per se, but progress of a value over a length of time? [more inside]
posted by booticon on Dec 5, 2008 - 8 answers

Mac OS X / Microsoft Office 2004 (Excel) crash and failed file recovery has left excel in an endless loop of restore and crash. Can anyone help me to find and delete the (unwanted) auto-saved excel sheet that is causing this problem? [more inside]
posted by urban greeting on Dec 4, 2008 - 3 answers

How do I work with a tab-delimited file when one of the fields is full of tabs? [more inside]
posted by epersonae on Dec 3, 2008 - 20 answers

MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today? [more inside]
posted by Rock Steady on Nov 14, 2008 - 13 answers

What's the best way to represent tagged data in Excel? I want to be able to give an item multiple tags. I would like to use these tags to generate pivot tables. But I'd rather not have to create a new column for each tag (at least, I'd rather not have to create them manually). [more inside]
posted by alms on Nov 7, 2008 - 6 answers

How can I make the X units of an excel chart weeks instead of days? [more inside]
posted by squorch on Nov 6, 2008 - 4 answers

How to bypass Excel macro warning or alternative to macro. [more inside]
posted by emjay on Nov 4, 2008 - 13 answers

I need to enter the following information into excel, but excel wants to transform one of them into a date format. This is for a statistics class and being used to make a graph of some kind. [more inside]
posted by Jackie_Treehorn on Oct 24, 2008 - 9 answers

Whenever I type (R) in MS excel, it automatically makes the registered trademark sign ®. How do I turn this off? [more inside]
posted by spec80 on Oct 21, 2008 - 4 answers