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.
Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card. [more inside]
I want to start using a spreadsheet to track and reconcile my various accounts. How do I start? [more inside]
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]
ExcelFilter: How do I convert a column of names formatted Smith, John into John Smith. Feasible?
Microsoft Excel help needed. [more inside]
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]
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.