You are here:
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.
I have worked with Excel for the past 12 years, in various environments.
Organizations
NYPC (New York PC users group)
NYPC (New York PC users group)
MCSE in Windows NT
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
A little bit of everything, I love knowing that there are so much still to learn
Excel is fun!
Excel is fun!
| 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 ..... |
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
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
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
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
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
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.