##
8 posts tagged with microsoft *and* Spreadsheet.

Displaying 1 through 8 of 8. Subscribe:

## stymied by excel

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.

Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card. [more inside]

## How can I use a spreadsheet to track my accounts?

I want to start using a spreadsheet to track and reconcile my various accounts. How do I start? [more inside]

## Turning a complex Excel spreadsheet with VBA functions into an online app

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]

## Is there a regexp for Excel?

ExcelFilter: How do I convert a column of names formatted

**into***Smith, John***. Feasible?***John Smith*## Microsoft Excel help needed

Microsoft Excel help needed. [more inside]

## Linking Excel and Word

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]

## Excel date problem

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.Page:
1