Excel/Expert Profile

Average Ratings

• Knowledgeability 9.84
• Clarity of Response 9.72
• Politeness 9.90
• Response Time(hr) 149.7
• Response Time(hr, last 90 days) 134.0

• Number of Questions Today 0
• Max Questions to be Asked in a Day 100
• Total Questions (since joining AllExperts) 2917
• Volunteer Since 2008-04-22
• Prestige Points 4310

Recent Reviews from Users

Read More Comments

Recent Answers from Richard Rost

2012-02-01 Complicated Question:

This is one of those things that is MUCH better done in a DATABASE program like Microsoft Access, not Excel. In Access you would create a table to store all of your individual ingredients (eggs, milk,

2012-01-31 Multiple worksheets w/ same info:

You can do it. Excel can reference values on other sheets or even in entirely different workbook files. The EASIEST way to do it is to open both sheets, COPY the data you want to have appear in the other

2012-01-11 auto increment when printing:

This isn't possible in Excel without some serious VBA programming. I would recommend using a database such as Microsoft Access to handle your invoices.     If you have Access and want to learn how to get

2011-12-28 VLOOKUP returns #N/A:

Try making your table range an ABSOLUTE REFERENCE...    =IF(ISBLANK(C2),"",VLOOKUP(C2,$A$2:$B$16,2,FALSE))    This works fine for the first two rows, but as you copy (or AutoFill) this formula down the

2011-11-16 Data entry in Sheet2 from sheet1:

Try this:    =IF(ISBLANK(Sheet1!A10),"",Sheet1!A10)    Here's some additional information on the IF function:    http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=AllExperts    I cover