Excel/Expert Profile

Average Ratings

• Knowledgeability 9.85
• Clarity of Response 9.86
• Timeliness 9.83
• Politeness 9.95

• Number of Questions (in Past 24 Hours) 0
• Max Questions to be Asked (in 24 Hour Period) 8
• Total Questions (since joining AllExperts) 3173
• Volunteer Since 2000-10-22
• Prestige Points 36836

Recent Reviews from Users

Read More Comments

Recent Answers from Richard Stephens

2009-09-04 A stickler:

Dani This could be accomplished by VBA but I don't know VBA well enough to help. However if you have a spare sheet you could use a vlookup and a table to give you what you want. ie Arrows Table

2009-09-02 COUNTIFS function:

Pelambre You can do it with a static number such as your =10 but not with the > sign as excel doesn't recognize that in a cell, it turns the value to text. Have a look at this link http://www

2009-08-27 Sum Question:

John You can use a Sum an If statement to get what you need. Type in the following assuming that C column starts at 2 and goes to 80 =SUM(IF(C2:C80>0,1,)*D2:D80) then press the Ctrl+Shift+Enter

2009-08-27 Linking Workbooks:

Lisa Do you have two instances of Excel open? ie do you open one workbook then start another instance of Excel and open the other workbook? If so open both workbooks from the first instance of Excel

2009-07-17 Want to put partial text from cell into another:

Doug You can copy the column with the full names into the third column then use Data Text to columns on the first column whith the space as the delimiter and it will split them into two columns.