You are here:

Excel/Expert Profile

Miguel Zapico

U.S.

Available

Expertise

I will try to answer any question that I can replicate in my current environment (I use Excel 2003 with Windows XP). This may include formula related questions on other Excel versions. Due to time limitations, I am not writing custom code to answer questions any more. Sorry for the inconvenience.

Experience in the area

I have worked with Excel for the past 12 years, in various environments.

Organizations
NYPC (New York PC users group)

Organizations

NYPC (New York PC users group)

Education/Credentials

MCSE in Windows NT

What do you like about this subject?

Excel is an incredible tool for many things. I specially enjoy its flexibility as a Business Intelligence tool, much better that many of the commercial applications on this field

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

A little bit of everything, I love knowing that there are so much still to learn

Something interesting about this subject that others may not know:

Excel is fun!

Something controversial or provocative about this subject

Excel is fun!

Average Ratings

Recent Reviews from Users

User	Date	K	C	T	P	Comments
tony	11/19/09	10	10	10	10	Thanks for the quick response. I didn't .....
MIKE	11/16/09	10	10	10	10	THANK YOU!!!!! That was a lightning fast .....
Julie	11/16/09	10	10	10	10	Thank you! Perfect!
Bill	11/15/09	10	10	10	10	This volunteers promptness was un-expected and very .....
Warren	11/12/09	10	10	10	10	Thank You Miguel, You rock like a .....

Recent Answers from Miguel Zapico

2009-11-20 Variable Tiers in Excel:

You can use the VLOOKUP formula for this. To do so, craft a table with the following layout: 0 $0.0395 100001 100000 $0.0282 $3,950 250001 250000 $0.0191 $8,180 500001 500000 $0.0180 $16

2009-11-20 Excel Macro:

It looks like the error may be on the For statement, you need to have two numbers instead of the Cells function, and use the Cells.EntireRow instead of the Rows. Something like: For nRow = MaxRow

2009-11-19 Adding formulas worksheet to worksheet:

This can be because of the use of absolute references. Check that the row number in the reference doesn't have a dollar sign in front. For example, a formula like this: =$A$1 Will not change the row

2009-11-18 excel solver:

You can use the column D to record the quantities, and then use a formula like this on E1, for example: =SUMPRODUCT(C3:C6,D3:D6) You can then use solver with the parameters being: Set target cell: E1

2009-11-16 ISTEXT cant return proper true/false results:

The problem here is that ISTEXT doesn't work with multiple cells as a parameter, so in this case it only checks the cell B4. If you want to look for the presence of N/A in the range, you can try with

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: