You are here:
- Home
- Computing/Technology
- Business Software
- Excel
- Douglas M. Smith
Excel/Douglas M. Smith
All Reviews from Users
Column Headings: K = Knowledgeability C = Clarity of Response T = Timeliness P = Politeness
N = Nominated for Expert of the Month
| Date | User | K | C | T | P | N | Comments |
|---|---|---|---|---|---|---|---|
| 2009-11-21 | Anil Nanduri | 10 | 10 | 10 | 10 | Yes | Thank you a lot for your help! It seems good. In fact I tried with the formula below....is there any issue by using the formula below? Please advise. IF(AND(A2>TIME(0,0,0),A2<=TIME(4,0,0)),"Zone I",IF(AND(A2>=TIME(4,0,1),A2<=TIME(8,0,0)),"Zone II",IF(AND(A2>=TIME(8,0,1),A2<=TIME(12,0,0)),"Zone III",IF(AND(A2>=TIME(12,0,1),A2<=TIME(16,0,0)),"Zone IV","")))) Best Regards, Anil Nanduri |
| 2009-11-20 | Sara | 10 | 10 | 10 | 10 | Yes | YOU ARE THE BEST!!!!!!!!!!! |
| 2009-09-17 | Hilde | 10 | 10 | 10 | 10 | Yes | Thank you so much Douglas. That was exactly what the doctor ordered :) I had been fumbling with so many variations with IF and ISERROR, and now that I read your formula it makes perfect sense of course! But even after hours of puzzling, I never managed it. So I am very grateful I was able to get your anwser. Kind regards, Hilde |
| 2009-08-20 | fkwan | 10 | 10 | 10 | 10 | Yes | Hi Thank you very much for your prompt response. It's great and work. It helps me a lot. Thanks again fkwan |
| 2009-08-19 | Setiadi | 10 | 10 | 10 | 10 | Yes | Thanks Doug! Your Formula is very useful for my daily office task! its speed up to create monthly report. |
| 2009-06-05 | fkwan | 10 | 10 | 10 | 10 | No | Thank you very much for your great help. |
| 2009-06-04 | John | 10 | 10 | 10 | 10 | No | Ha! It works. Thank you so much. |
| 2009-04-28 | Troy | 10 | 10 | 10 | 10 | Yes | PERFECT - thank you very much - it makes perfect sense. Wish I could of figured it out - guess that is why you all are called the EXPERTS. Million thanks |
| 2009-04-23 | Tom | 10 | 10 | 10 | 10 | No | That makes sene. I was just hoping I could do the whole thing in the if statment like if "yes" format.text=green,if"no",format.text = red or something to that effect. It seems like the If statement must be done first and the formatting second. It just seems more efficient to do it as I enter the formula. Thanks |
| 2009-03-16 | Eric | 10 | 10 | 10 | 10 | Yes | Doug, thank you very much... Top input. I couldn't find any reference to this in the forums and helps I went through. Take care. |
| 2009-03-14 | troy | 10 | 10 | 10 | 10 | Yes | Worked perfectly - million thanks |
| 2009-02-24 | John | 10 | 9 | 9 | 10 | Yes | Thanks so much!!! |
| 2009-02-21 | David | 10 | 10 | 10 | 10 | Yes | PERFECT, PERFECT, PERFECT! Thanks you so much for the help. You were fast, accurate and the best! Yes, yes, yes for Volunteer of the Month! And the Year! |
| 2009-02-13 | annemarieke kleijn | 10 | 10 | 10 | 10 | No | Thank you very much! This is the perfect solution. |
| 2009-02-12 | paul | 10 | 10 | 10 | 10 | No | |
| 2009-02-10 | Raymond | 10 | 10 | 10 | 10 | No | Thank you very much sir.. it was indeed very helpful...Appreciate your quick reply... |
| 2009-02-09 | MARIO | 10 | 10 | 10 | 10 | Yes | Doug's reply helped me solve the problem. Reply was very quick and precise.Keep up the good work we all appreciate your service very much ,many thanks. Mario. |
| 2009-01-19 | dave | 10 | 10 | 10 | 10 | Yes | Great solution! Thank you! |
| 2009-01-11 | Mujahid | 10 | 10 | 10 | 10 | No | Thanks a lot Mr. Douglas M. Smith, I really very thankful to you, you solved my big problem thanks again |
| 2009-01-09 | Nico Smith | 10 | 10 | 10 | 10 | No | Your assistance is greatly appreciated, thanks a lot. Nico Smith |
| 2009-01-09 | Jason | 8 | 10 | 10 | 10 | No | |
| 2009-01-07 | Dave | 10 | 10 | 10 | 10 | Yes | Douglas Excellent, many thanks, you've saved me a whole bunch of work! |
| 2008-12-10 | Andy | 10 | 10 | 10 | 10 | Yes | Thank you for the excellent answer. What I like most about it was how easily it was to grasp it. |
| 2008-12-09 | Mike | 10 | 10 | 10 | 10 | Yes | Thanks Douglas Just the job, much more efficient than my method. Regards, Mike |
| 2008-12-06 | anwar | 10 | 10 | 10 | 10 | Yes | Thanks for valuable knowledge. Best of Luck for your all ambitions.. |
| 2008-11-12 | Barrett | 10 | 10 | 10 | 10 | Yes | Quick and concise! Thanks! |
| 2008-10-30 | Andrew | 10 | 10 | 10 | 10 | Yes | I really appreciate the quick response. The answer was very helpful! |
| 2008-10-24 | Deborah | 10 | 10 | 10 | 10 | Yes | This is great and has saved me loads of time, thanks very much!!! I'm so impressed with the speediness of this service :) |
| 2008-10-21 | patrick gutierrez | 10 | 10 | 10 | 10 | No | thanks very much! |
| 2008-10-21 | eran | 10 | 10 | 10 | 10 | No | thanks smith. it is working nicely. |
Page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next
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
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
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Douglas M. Smith
Expertise
I specialize in solving formula, feature and structure related problems. I know many tricks to help make your spreadsheets and processing more efficient.
Experience
Brainbench MVP for MS Excel
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
©2009 About.com, a part of The New York Times Company. All rights reserved.