There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data. asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle on Mar 17, 2011 - 6 answers

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 - 7 answers

I want to start using a spreadsheet to track and reconcile my various accounts. How do I start? [more inside]
posted by reenum on Sep 30, 2009 - 9 answers

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu on Sep 12, 2008 - 2 answers

ExcelFilter: How do I convert a column of names formatted Smith, John into John Smith. Feasible?
posted by furtive on Feb 9, 2006 - 8 answers

Microsoft Excel help needed. [more inside]
posted by teem on Jan 11, 2006 - 11 answers

Is there some way to link an Excel spreadsheet and Word document such that a portion of the Word document will update automatically from changes in the Excel file? [more inside]
posted by nelleish on May 30, 2005 - 6 answers

RE: Excel: 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 - 10 answers