Douglas M. Smith - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: 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.
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

Ask a Question	View Past Answers	View Ratings

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
Prestige Points: 12286
Knowledge	9.92 Best of the best
Clarity of Response	9.93 Best of the best
Timeliness	9.98 Best of the best
Politeness	10.0 Best of the best
Number Of Questions (in Past 24 Hours)		1
Max Questions to be Asked (in 24 Hour period)		2
Total Questions (since joining AllExperts)		1493

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	11/12/08
10	10	10	10	10/30/08
10	10	10	10	10/21/08
10	10	10	10	10/21/08
10	10	10	10	10/24/08

User Comments

Quick and concise! Thanks!
(Barrett on 11/12/08)

I really appreciate the quick response. The answer was very helpful!
(Andrew on 10/30/08)

thanks smith. it is working nicely.
(eran on 10/21/08)

thanks very much!
(patrick gutierrez on 10/21/08)

This is great and has saved me loads of time, thanks very much!!! I'm so impressed with the speediness of this service :)
(Deborah on 10/24/08)

View All Comments

Ask a Question	View Past Answers	View Ratings

Recent Answers from Douglas M. Smith

2008-11-14 Formula: Hi John, Yes, you left out the "" argument in the formula: IF(LEN(A1)>8,IF(ISERROR(VALUE(MID(A1,9,1))),"",MID(A1,9,1)),"") You don't have to retype the formula. You can just copy the whole thing...

2008-11-12 military time trouble: Hi Barrett, You need to enter the colon (13:10) to make it work. Time values are numbers between zero and one. For example: 13:10 is 0.548611111111111 in decimal format. If you enter 1310 in a time...

2008-11-11 Forumla: Hi John, Give this a try. It's all one big formula but I've spaced it out so you can read it. It works with or without the spaces: =IF(ISERROR(VALUE(LEFT(A1,1))),"",LEFT(A1,1)) & IF(ISERROR(VALUE(MID(A1...

2008-11-11 Formula help in excel: Hi Jeff, There are lots of pasting options available if you use Paste Special (Edit Menu) instead of Paste. You can paste just the value (result) of the formula by selecting the Values option in the...

2008-10-30 Help with complex conditional formulas.: Hi Andrew, You have identified the correct functions to use, but some assembly is required. The basic form of an IF statement is: =IF(test, true result, false result) The "test" can be very...