About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert Login (Experts Only)
About Us  ·  FAQ  ·  Tell Friends About Us  ·  Link To Us  ·  Free Encyclopedia  ·  Disclaimer  ·  Tech Support   
  You are here:  AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Craig

Expertise:  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.

Experience in the area
10 years

Education/Credentials
BA - Business '96, CPA '98

Ask a Question       View Past Answers       View Ratings            
Average Ratings
Prestige Points: 3690
Knowledge   9.85   Best of the best
Clarity of Response   9.74   Best of the best
Timeliness   9.72   Best of the best
Politeness   10.0   Best of the best
Number Of Questions
(in Past 24 Hours)
0
Max Questions to be Asked
(in 24 Hour period)
2
Total Questions
(since joining AllExperts)
483
Recent Reviews from Users
KnowlClarityTimePolitenessDate
1010101011/18/08
1010101011/19/08
1010101011/03/08
1010101010/29/08
1010101010/29/08
User Comments
Thanks for info, but would take too long that way, i have about 1200 address to copy & paste, just thought there might be a faster way to do it thank
(June on 11/18/08)
I'm not sure I'm giving you all the information; however, I have since figured out my issue. The formula is correct and does get me what I need now t
(Lorena on 11/19/08)
Thanks Craig! I'll try your suggestions. Your quick reply was greatly appreciated!
(Rosy on 11/03/08)
Appreciate the help
(Lance on 10/29/08)
View All Comments
Ask a Question       View Past Answers       View Ratings            

Recent Answers from Craig
2008-11-18  moving info from rows down into column Hi June, Depending on the complexity of the information, you can transpose this information. Highlight your horizontal data and choose Edit/Copy Select a cell below your data, where you want to...
2008-11-18  Calculating Percentage Increase Hi Lorena, I'm not sure this is going to completely solve your problem, as I don't think I completely understand what you are doing, but... Based on your descriptions, if E9 is already a negative...
2008-10-31  Excel 2000 files transferred to Excel 2003 Hi Rosy, This is not my area of expertise, but here are a couple of possibilities: 1. MAIL MERGE Go through the whole mail merge wizard "thing" on the Tools menu until you get to Select Data Source...
2008-10-31  EXCELL CHECK BOX Hi Jeff, Sorry for taking so long to get back to you, but I couldn't remember what the trick was. If you use the Forms toolbar - View/Toolbars/Forms to select your checkbox, you can right click...
2008-10-29  IF and AND syntax Hi Lance, Try this: =IF(AND(A2<>"",B2<>""),A2,IF(AND(AND(A2<>"",B2=""),A2<>"",C2<>""),A2,"")) I removed ,"" after the second A2. I also added a comma before the fourth A2. Hope that does what...
More Answers for "Excel"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.