Excel/Expert Profile

Average Ratings

• Knowledgeability 9.83
• Clarity of Response 9.83
• Politeness 9.83
• Response Time(hr) 13.4
• Response Time(hr, last 90 days) 34.7

• Number of Questions Today 0
• Max Questions to be Asked in a Day 1
• Total Questions (since joining AllExperts) 49
• Volunteer Since 2008-02-13
• Prestige Points 180

Recent Reviews from Users

Read More Comments

Recent Answers from JP

2008-04-16 Incremental:

The easiest solution is…..    I assume that your formulas begin with and equal sign (although the same concept would work if they begin with plus sign; however with a plus sign you would need to be slightly

2008-04-13 excel dates:

There are 2 options that I am aware of:    Opt1 – choose manual calculation function under Tools/options/calculation.  Opt2 – Enter in the Now or Today function in the same cell of every worksheet.  Select

2008-04-04 excel formulas:

To truncate, done using the Trunc function basically means to cut off a number at a given point or a hard round down.  So given 1/3 = 0.333333333...3forever, then, trunc(1/3,4) would equal 0.33330000000

2008-04-03 vlookup on pivot table:

Pivot Tables report data in an outline format.  I am not aware of a way to format the table so that all values are filled down which would convert pivot outline into a usable pivot list/dbase.       To

2008-04-02 saved excel worksheet in 2 different my document folders:

The only way to sync the folders is to select all files from one folder and copy past to the destination folder.  The system will automatically ask for you input to replace the current file with the existing