You are here:
I can answer most general questions, including formatting, shortcuts, pivot tables etc. I have just started using macros, so vba is not my strong suit. I also enjoy explaining the solution at the questioners level of understanding. I am an accountant by trade, so that is my primary area of expertise, but I am willing to tackle just about anything.
I've been working in excel for 15+ years
BA - Business '96, CPA '98
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Dennis Smith | 02/01/12 | 10 | 10 | 10 | |
| A. | 01/23/12 | 1 | 1 | 1 | Expert asked for money for what other ..... |
| Gabor Nyitrai | 12/05/11 | 10 | 10 | 10 | Very helpful reply. Many thanks |
| Susie | 11/17/11 | 10 | 10 | 10 | Thanks Craig, I'll try that tomorrow with ..... |
| Randy | 11/15/11 | 10 | 10 | 10 | Thank you so much! I was on ..... |
Hi Dennis, I hope this is not too simplified, but I think this should work: in C1, type =IF(A1=B1,"Y","N") If a1 is equal to b1, then leave a Y, if not then leave an N. You can then drag this
Hi Samantha, If you have Excel 2007 or 2010, this will be really easy. Highlight the pallet ID column in Sheet2 and then go to the Home tab and choose "Conditional Formatting", then Highlight Cell
Hi Sara, This should be a matter of changing your absolute references. Typically with conditional formatting, excel tries to guess what you are doing. I assume that your conditional format shows something
Hi Mike, I've done something similar, but this is one of the better documented explanations of how to do what it looks like you are trying to do. Try one of these links: http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/
Hi Gabor, You could put all this into one formula, but I think it is easier to explain by having a column that determines your price and then another column that multiplies the price x quantity, so
Answers by Expert:

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