Excel/Expert Profile

Douglas M. Smith

U.S.
On Vacation
returns 12/03/2009
Expertise

I specialize in solving formula, feature and structure related problems. I know many tricks to help make your spreadsheets and processing more efficient.

Past/Present Clients

Gannett, Fannie Mae, Pepsi, Nortel, Procter & Gamble, BellSouth, Blue Cross Blue Shield of NC, NC Central University, GlaxoSmithKline, Maintenance Excellence Institute, AAI Pharmaceuticals, Blue Cross Blue Shield of SC, Brainbench.com

What do you like about this subject?

Excel is the most under-utilized application in the world. I love showing people how to turn it loose.

Something interesting about this subject that others may not know:

Check out my Excel Web Seminar on June 25: http://goto.webinarinstitute.com/go/8742 My website: www.abundant-solutions.com

Something controversial or provocative about this subject

Life's too short to re-key data.

Average Ratings

  • Knowledgeability 9.92
  • Clarity of Response 9.93
  • Timeliness 9.98
  • Politeness 10.0
  • Number of Questions (in Past 24 Hours) 0
  • Max Questions to be Asked (in 24 Hour Period) 2
  • Total Questions (since joining AllExperts) 1640
  • Volunteer Since 2002-12-20
  • Prestige Points 13196

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Anil Nanduri11/21/0910101010Thank you a lot for your help! .....
Sara11/20/0910101010YOU ARE THE BEST!!!!!!!!!!!
Hilde09/17/0910101010Thank you so much Douglas. That was .....
fkwan08/20/0910101010Hi Thank you very much for your .....
Setiadi08/19/0910101010Thanks Doug! Your Formula is very useful .....

Recent Answers from Douglas M. Smith

2009-11-20 Conditional Formatting on a formula:

Hi Sara, That's very strange, I think it should work as you have it. However, if you re-order the testing and make ="Closed" the first test instead of the last one, it should work for you. Doug

2009-11-20 Converting different times into slots:

Hi Anil, Time values are really only a decimal value representing a point in a day, with a whole day being equal to 1. Examples: Noon would be 0.5, 6am would be 0.25, 4am would 0.333333, etc. A

2009-10-03 Excel Formula - A doozie:

Hi Bruce, Sorry for the delay, I've battling the flu. Time values in Excel are really just the decimal part of a day. Examples: 6:00 am is 0.25, noon is 0.5. To convert a time to the decimal number

2009-09-15 lots of ifs:

Hi Hilde, The easiest solution would be to select all the date cells and use the Replace command (Edit menu) to replace all the #VALUE! entries with nothing. Then your formula should work as-is. Otherwise

2009-08-19 excel 2007 Conditional formatting for dates:

Hi Dan, You will need to set up three cases to do this. In the Conditional Formatting dialog box, set it up for three cases and select the "Formula Is" option for all three. Use the following formulas

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:

Ask Experts

Volunteer

©2009 About.com, a part of The New York Times Company. All rights reserved.