Bob Umlas - 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: Bob Umlas

Expertise: I`m a Microsoft Excel MVP (Most Valuable Professional) and have been since the inception of the program in 1995. I can answer every kind of Excel question except: API, Importing/exporting to other programs (powerpoint, word,...)

Experience in the area
Worked with MS Excel since version 0.99 (on the Mac!). Was contributing editor to Excellence Magazine, having written >300 articles. John Walkenbach said of me "I finally met someone who knows as much about Excel as I do."

Publications
Excellence, The Expert, Microsoft

Awards and Honors
MVP
Led sessions for the Convergence 2004-2006 seminar on Excel tips & tricks

Ask a Question	View Past Answers	View Ratings

What do you still hope to achieve/learn in this field? XML

Something interesting about this subject that others may not know: See my book, This isn't Excel, it's Magic! at http://www.iil.com/iil/excelmagic

Average Ratings
Prestige Points: 62488
Knowledge	9.92 Best of the best
Clarity of Response	9.86 Best of the best
Timeliness	9.95 Best of the best
Politeness	9.93 Best of the best
Number Of Questions (in Past 24 Hours)		7
Max Questions to be Asked (in 24 Hour period)		8
Total Questions (since joining AllExperts)		6363

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	12/02/08
10	10	10	10	12/02/08
9	10	10	10	11/27/08
10	10	10	10	11/25/08
10	10	10	9	11/25/08

User Comments

His suggestion was right on the money!!!
(Bill on 12/02/08)

Thanks - the fix works great. I learned something new. Fred
(fredhollowell on 12/02/08)

Lot of thanks by kathir
(kathir on 11/27/08)

Bob Umlas is tops. His solutions are always perfect for the application. Thanks Bob
(Robert on 11/25/08)

Thanks a ton Bob. That was really very helpful
(Aditya on 11/25/08)

View All Comments

Ask a Question	View Past Answers	View Ratings

Recent Answers from Bob Umlas

2008-12-02 Small change in large macro: To do this: cell D3 in worksheet "(4) Watch List" to be copied to The next available row in column "B" in worksheet "RT Data" AND Cell D4 in worksheet "(4) Watch List" to be copied to The next available...

2008-12-02 Vlookup across multiple sheets: On the assumption that the product code is in the same ROW on each sheet, you can do this: Create 2 more sheets - name them First and Last - put First before the first sheet you want to add up and Last...

2008-12-01 IF formula or any other.: THis is the first time you're mentioning column X, I believe, but I need to see that layout -- why not send me a sample workbook to bobumlas@yahoo.com, use subject of "AllExpertsQ" and I'll show you how...

2008-11-30 IF formula: Sorry - still unclear. First, I don't know what that 48 & 44 are at the bottom of your example. I don't understand how you'd calculate what you say you want in C1 (partly because C1 says "STDTIME"). If...

2008-11-29 IF formula: There are often other ways to get what you want, but you didn't say what you're trying to do. An example would help. Given that, there's no way around the 7-nested limit using the IF-statement in the traditional...