You are here:

Excel/Expert Profile

Chad Welch

U.S.

Maxed Out

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.

Average Ratings

Recent Reviews from Users

User	Date	K	C	T	P	Comments
Alex	11/20/09	10	10	10	10	Thank you!
dave	11/12/09	10	10	10	10	perfect and simple. thanks chad!!!
Sancho	10/05/09	10	10	10	10	Hi Chad, Thank you for the very .....
Andrew	04/12/09	10	10	10	10	Excellent help. cheers
Ann	04/06/09	10	10	10	10	Thanks for the great help

Recent Answers from Chad Welch

2009-11-19 Minutes formula:

Alex, The problem is that Excel doesn't recognize :00:30 as a time. It will however recognize 0:00:30 as 30 seconds. You can "fool" Excel into recognizing the value as a time by using a formula to precede

2009-11-10 assigning weights to dropdown list selection:

Hi Dave, If I understand your request correctly, the VLOOKUP function is the one you need. Just paste the following formula into D31/33/35 (adjusting the reference to C31 of course). =VLOOKUP(C31,$D$2:$E$22

2009-11-07 Password protect cell editing:

Thorsten, That is a functionality that is built into Excel. You don't mention which version of Excel you have and the way to access it is slightly different in Excel 2007 compared to previous versions

2009-10-11 IF (multiple match tests) THEN:

Hi Paul, VBA programming is a very literal language, so it is necessary to be this specific. If you need to ensure that every variable is an empty string, then you have to check each one. That said, it

2009-10-04 Equivalent Networkdays:

Sanch, A couple of your lines have been commented out. As it stands now, your code will return the same result as NETWORKDAYS. To work properly, uncomment the 2 lines in your For loop: If FindItemInArray(dteHol

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

Encyclopedia

Browse Answers: