Functions

Conditional Formatting with Partial name search
Is there a way to use conditional formatting to search two lists of names, and highlight the differences by only highlighing those with last name differences. (My spreadsheet contains over 250 names) Example: Column A: Jones, Dave Smith, Bob Brown, Sally White, Mary Column B: Jones, Dave V. Smith, Bob ... 10 Feb 2010 13:26

Custom views in Excel
Is it possible to have a custom view for multiple worksheets with the same name within the same workbook? As an example, I have a workbook that has 10 worksheets. Each worksheet has different print areas. I want to be able to use the worksheet to report both monthly and quarterly data. The monthly data woul... 10 Feb 2010 12:17

How do I multiply ALL CELL in spreadsheet at once by .5 ?
I am trying to multiply all the cells in my spreadsheet by .5 . each cell has a differant value but need to multiply by .5 to update. Can I do the whole sheet, or row, or column at once without having to do each cell individually??? Please help... would take time off my busy schedule. Thank you, ... 10 Feb 2010 13:26

TransferSpreadsheet to colored fields
TransferSpreadsheet to colored fields Hello, I have an MS Access file that transfers data to Excel using the TransferSpreadsheet method… It works fine, but I’d like to programmatically color the fields based on the header values—or, even simpler, color the first 4 fields in red (e.g.), the next 3 blue, etc,... 10 Feb 2010 11:09

how do I convert date format yyyymmdd to mm/dd/yyyy
how do I convert date format yyyymmdd to mmddyyy I have rows of dates displayed as yyyymmdd (ie 20100131) I want them displayed as regular dates (ie 01/31/2010) ... 10 Feb 2010 12:17

Excel - Calculate age from DOB in years, months days
Might seem obvious but I can't find an answer in Excel Help. I am trying to calculate age in years, months and days by subtracting cell containing date of birth from cell containing today function. Using 2007. Many thanks. ... 11 Feb 2010 06:07

In excell 2003, increasing number of items shown in drop down list
I am trying to increase the number of lines to be displayed in the drop down list, using MS office 2003, excell. I have read contributions to the question possed on 8/11/2007 8:00 PM , but sadly it does not provide the "Format Control" that should enable me to change the mnumber of dropdown lines to be shown. ... 10 Feb 2010 10:01

how to vlookup of one cell by starting 2 digits of another cell?
how to vlookup of one cell by starting 2 digits of number in another cell? ... 10 Feb 2010 00:09

How do I get the MSNStockQuote function in Excel?
... 11 Feb 2010 18:30

Count with multiple criteria in multiple cells
Try this =SUMPRODUCT((D2:D3565="0 Paper")*(F2:F3565=1)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "MadProphet" wrote: I am trying to get a count of how many rows have a value ... 9 Feb 2010 11:43