About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert 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: Chad Welch

Expertise:  I have a lot of experience with VBA; Sub procedures, functions etc. I am also very familiar with array formulas.

Experience in the area
I've worked with Excel for several years. I've been answering questions on various groups and lists for a while.

Organizations
Brainbench MVP for MS Excel.

      View Past Answers       View Detailed Ratings            
Average Ratings
Prestige Points: 8340
Knowledge   9.95   Best of the best
Clarity of Response   9.94   Best of the best
Timeliness   9.93   Best of the best
Politeness   10.0   Best of the best
Number Of Questions
(in Past 24 Hours)
0
Max Questions to be Asked
(in 24 Hour period)
1
Total Questions
(since joining AllExperts)
867
Recent Reviews from Users
KnowlClarityTimePolitenessDate
1010101006/03/08
1010101002/26/08
10101002/07/08
1010101012/02/07
1010101011/20/07
User Comments
Thanks Chad Excellent response, well explained.
(John on 06/03/08)
Thank you for your expert advice! I do appreciate it. Dick
(Dick on 02/26/08)
Chad provided a simple, clear response. Thanks!!!
(Joe on 02/07/08)
Yeah that was what I needed. Thanks for your great advice. It really helped me a lot. Good advice. 10/10
(Leher on 12/02/07)
Chad, Thanks so much for your help! So simple, when you see the answer. More thanks thou, for explaining the process step by step (this will av
(Grant on 11/20/07)
View All Comments
      View Past Answers       View Detailed Ratings            

Recent Answers from Chad Welch
2008-08-20  Sum a Qty based on date range in another colum Ilene, This can be done, but you need to use an Array Formula to do it. Chip Pearson has a great tutorial on array formulas at http://www.cpearson.com/excel/ArrayFormulas.aspx. In essence the array...
2008-08-19  XL formula Deborah, Yes there is a function that will do what you need. It is the VLOOKUP function. Assuming the associates and rates are in Sheet1 range A2:B20 the formula in B3 or worksheet 2 will be: =VLOOKUP(B3...
2008-06-02  Sheet Protection John, Yes it is possible. While the sheet is unprotected, right click on the cell(s) that you would like to still have available. Choose "format cells." On the "Protection" tab uncheck "Locked." Protect...
2008-04-11  Excel pull down list Sharon, There are two types of pull down lists (or combo boxes) in Excel. If you use the combo box from the Forms toolbar, there isn't an easy way. Instead use the combo box from the "Controls Toolbox"...
2008-02-19  User Input Dave, The GetOpenFilename method will do exactly what you need. It uses the open file dialog box to let the user browse to a file and select it. The short snippet of code below gives an example. There...
More Answers for "Excel"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.