Richard Rost - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

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

Knowl	Clarity	Time	Politeness	Date
9	9	9	9	12/02/08
8	10	8	10	11/25/08
10	10	10	10	11/17/08
10	10	10	10	11/17/08
10	10	5	10	11/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...