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

How can I take a picture, organize and create a URL for each SKU in a mini-warehouse? [more inside]
posted by schindyguy on Nov 7, 2009 - 4 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

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]
posted by rollick on Nov 4, 2009 - 9 answers

I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column. [more inside]
posted by malcommc on Oct 26, 2009 - 13 answers

How do I store a string in one cell in Excel and interpret it as a (or for a) function in another cell? More info inside. [more inside]
posted by nickerbocker on Oct 22, 2009 - 10 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

Excel help with AVERAGEIFS: I need to generate an average figure per row, but the cells to be averaged need to meet two criteria. [more inside]
posted by blahblahblah on Oct 20, 2009 - 5 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

How can I set up Excel 2003 to automatically include the file name and path on every spreadsheet when printed? [more inside]
posted by Wroksie on Oct 20, 2009 - 7 answers

Can you reccommend VBA tutorials, particularly for MS Excel 2007? [more inside]
posted by Librarygeek on Oct 19, 2009 - 1 answer

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

Help! My job requires IT knowledge I don't have. Two questions. [more inside]
posted by Suciu on Oct 12, 2009 - 8 answers

How to merge data from two excel sheets into one? [more inside]
posted by willy_dilly on Oct 9, 2009 - 6 answers

I need a formula to help calculate the number of days as compared to a range. Importing a CSV for a query to show bookings within the date range of 9/1 to 9/30. Some bookings are booked through the entire month and some are partial. I need to figure out the number of days or percentage for the bookings that don't run all the way through the query range. [more inside]
posted by malcommc on Oct 1, 2009 - 9 answers

I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]
posted by kenzi23 on Sep 30, 2009 - 2 answers

Need formula to calculate a lease rate factor from a %. [more inside]
posted by thinktwice on Sep 24, 2009 - 1 answer

I coach a high school soccer team. Each practice we go through a routine which involves repetitions of various skills. The number of repetitions accomplished by a player for each skill is recorded in an excel spreadsheet for ranking purposes. I want to determine the rate of improvement so the players can see their progress and who's improving most. Is there a simple excel function that would help me do this?
posted by TheManticore on Sep 19, 2009 - 2 answers

How to remove content from table that is not in other column [more inside]
posted by tseo on Sep 18, 2009 - 4 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

This should be super easy to do on Excel, right? [more inside]
posted by water bear on Sep 9, 2009 - 15 answers

Why is the functionality of an Excel Pivot table different depending on whether you use a list or a multiple consolidation range? [more inside]
posted by DZ-015 on Sep 4, 2009 - 1 answer

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

Excel2007Filter: I want to be able to search information between two things in a single cell in Excel. So a cell may have 4-9 typed in it, but I want that cell to be highlighted if a user searches for 7. Or 4. Or anything between 4 and 9 inclusively. (More details and a screenshot of the spreadsheet inside.) [more inside]
posted by sperose on Sep 2, 2009 - 3 answers

How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]
posted by SansPoint on Sep 2, 2009 - 5 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

MathFilter, NumericSimplificationFilter, RecursionFilter, ExcelFilter: Where X_1,X_2,...,X_n can be any number, is there a name, simplified series, or equation to describe: (X_1)+(X_1+X_2)+(X_1+X_2+X_3)+...+(X_1+X_2+...+X_n) ? Seriously seriously insane exel implementation question inside. [more inside]
posted by Nanukthedog on Aug 28, 2009 - 16 answers

Another stupid excel question. [more inside]
posted by TheBones on Aug 26, 2009 - 5 answers

I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily? [more inside]
posted by soulbarn on Aug 12, 2009 - 3 answers

Can I set up an Excel spreadsheet so the user is presented with a series of fields, like a form, instead of having to enter data directly into the cell? [I'm having a hard time even wording this question properly, so I haven't been able to find the answer anywhere. I turn to AskMe. Further explanation follows...] [more inside]
posted by The Deej on Aug 11, 2009 - 14 answers

Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 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

Trying to get some modified AVERAGE results in Excel. [more inside]
posted by FatherDagon on Aug 5, 2009 - 5 answers

Can anyone recommend a good book for medium-advanced level vba programming for Excel?
posted by Miss Otis' Egrets on Aug 4, 2009 - 0 answers

ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please? [more inside]
posted by cholly on Jul 30, 2009 - 4 answers

What are some affordable alternatives to Tableau for data visualization, plotting, etc? [more inside]
posted by ttyn on Jul 29, 2009 - 4 answers

Question on Excel date format changes- please help hivemind, you are my only hope! [more inside]
posted by TheBones on Jul 22, 2009 - 10 answers

Please help an Excel noob with something extremely simple. [more inside]
posted by turgid dahlia on Jul 21, 2009 - 9 answers

Excel 2007 - How do I stop the scrolling function from jumping to the top/bottom of a cell? This happens using the mouse scroll wheel, when clicking the scroll wheel and moving the mouse (free scroll type of thing), and when using the scroll bars onscreen. [more inside]
posted by Merlin144 on Jul 18, 2009 - 3 answers

Can I do this in Excel and/or Access? 'This' is a bit complicated so it's explained inside. [more inside]
posted by nooneyouknow on Jul 17, 2009 - 13 answers

How do I create an inventory database using Excel? [more inside]
posted by Seeba on Jul 14, 2009 - 10 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

How to automatically breakout Excel worksheets based off one "master' worksheet? [more inside]
posted by entropicamericana on Jul 9, 2009 - 9 answers

I have an excel file with a column of dates, in the xx/xx/xxxx format. I would like to strip out the month and day information, so I could just have a column that shows the year, but excel's method of representing dates as serial numbers has foiled every attempt. Any ideas? [more inside]
posted by M.C. Lo-Carb! on Jul 8, 2009 - 8 answers

Asking_for_friendFilter/ExcelFilter: I’ve built a pretty basic calculator in Excel to help people figure out how much to bill for partial months vs. full months. As you can guess, there's... [more inside]
posted by littlerobothead on Jul 8, 2009 - 2 answers

Is it possible for an email attachment in Outlook to 'update' itself from a network drive? My attachment is not the same now as it was when I first received and viewed it. [more inside]
posted by youngergirl44 on Jul 7, 2009 - 13 answers

I need to merge two Excel sheets with some common fields, but the most advanced formula I've ever used is Autosum. [more inside]
posted by thebazilist on Jul 7, 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

I'm looking for a randomized list of every nation state in the world, preferably in spreadsheet column form. Is there anything like this?
posted by billtron on Jun 29, 2009 - 8 answers