You are here:

Excel/Expert Profile

Chad Welch

U.S.

On Vacation
returns 12/31/2012

Expertise

I am a heavy user of Excel and VBA. Unfortunately, I do not have the time to help you design a complex project. However, I am very happy to help troubleshoot problems you are encountering or provide direction with formulas or snippets of code.

Experience in the area

I have created several complex spreadsheets for use in data collection/aggregation as well as scientific laboratory studies and procedures.

Organizations

Brainbench MVP for MS Excel.

Education/Credentials

AS - Computer Science (emphasis on programming) BS - Chemistry

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
Peggy Martes	01/09/12	10	10	10	I can't Thank you enouch. I can't .....
Scott	01/02/12	10	10	10
Eliza	06/10/10	10	10	10	Thank you! Somehow I knew it was .....
Michele	03/12/10	10	10	10	Hi Chad Still trying to get to .....
Vikki	02/13/10	10	10	10	Thanks Chad. The code you gave me .....

Recent Answers from Chad Welch

2012-01-08 VBA count help in a range across multiple sheets:

Hi Bill, You are very close. The problem is that you are looking at the range, but you need to look at individual cells or a formula that will consolidate the range. My guess is that the second option

2012-01-07 reply to your email:

Hi Peggy, It's good to hear from you again. This can be done by using a few nested IF functions in Excel. So if the census number is in cell B2, copy the following into B3, B4 & B5 to get the RN, PCT

2012-01-03 VBA - Goal Seek:

NCA, That error means that VBA cannot load something that is referenced in the code. Unfortunately, when it happens the line that is highlighted usually isn't the one causing the error. My guess is that

2012-01-02 Dealing with Blank Values:

Hi Scott, Thanks for using AllExperts. The following formula should work for you. It checks column A, if it is blank then it will return a blank. Otherwise it returns the result of your formula. =IF(A4=""

2010-06-01 Excel date formula:

Hi Eliza, The problem lies in the way Excel handles dates. It converts the date to the number of days since 1/1/1900, so 9/1/2006 is stored as 38,961. In your formula, the 09/01/2006 is interpreted as

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: