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: Richard Rost

Expertise:  I am happy to answer any questions about Microsoft Excel. If you have an Excel problem, let me help you with it. Also, please be sure to check the Microsoft Excel Tips & Tricks and Microsoft Excel Tutorials sections of my web site.

Experience in the area
I have been using Microsoft Excel since the very early Windows 3.1 versions. I have been teaching Microsoft Excel in the classroom since 1994, and online through computer tutorials since 2002.

Organizations
I have been volunteering on AllExperts in the categories of Microsoft Access, Visual Basic, and Weight Loss for many months now.

Publications
I have created a line of computer tutorials online at www.ExcelLearningZone.com and www.599CD.com/Excel.

Education/Credentials
Personally, I am self taught. I've learned everything I know from books and trial & error. If I don't know the answer, I know how to find it.

Past/Present Clients
I have over 20,000 happy clients worldwide.

Ask a Question       View Past Answers       View Ratings            
Average Ratings
Prestige Points: 990
Knowledge   9.71   Best of the best
Clarity of Response   9.52   Best of the best
Timeliness   8.58   Excellent
Politeness   9.94   Best of the best
Number Of Questions
(in Past 24 Hours)
0
Max Questions to be Asked
(in 24 Hour period)
3
Total Questions
(since joining AllExperts)
561
Recent Reviews from Users
KnowlClarityTimePolitenessDate
12/02/08
101011/25/08
1010101011/17/08
1010101011/17/08
10101011/17/08
User Comments
Thank you for the help
(Arno on 12/02/08)
Hello Richard, I already found the answer. It's a combination of sumproduct, row and offset. It took me some time to figure it out but works like a
(Sanne on 11/25/08)
Oh my God!! Wow - THANK YOU, THANK YOU!! I tried everything... you're great!
(Sharon on 11/17/08)
Thanks, your advice appears to be very straight forward
(Paul on 11/17/08)
View All Comments
Ask a Question       View Past Answers       View Ratings            

Recent Answers from Richard Rost
2008-11-30  function That's going to be pretty complicated. I would do it with a loop and a custom VBA function. Basically while the last digit is not 9, add a penny until it is. I can't think of any NON-programming way to...
2008-11-29  Body of outlook e-mail from Excel Yes. When I copy and paste from Excel to Outlook 2003 everything (fonts, colors, etc.) copy too. I don't know why it isn't for you. Let me know if you have any other questions or comments. Also...
2008-11-29  conditional formatting I don't believe so, no. Sorry. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT EXCEL VIDEO TUTORIAL. Go to http://www...
2008-11-28  sorting You'll have to manually renumber it (I would recommend Autofill) or write a macro to recreate your numbered row. Let me know if you have any other questions or comments. Also, be sure to visit my...
2008-11-27  Hyperlinks Make your formula in cells C15 and D15 then select them both, then autofill across. Excel should automatically update your function. Let me know if you have any other questions or comments. Also...
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.