Excel/Expert Profile

Average Ratings

• Knowledgeability 9.83
• Clarity of Response 9.75
• Timeliness 9.90
• Politeness 9.91

• Number of Questions (in Past 24 Hours) 1
• Max Questions to be Asked (in 24 Hour Period) 3
• Total Questions (since joining AllExperts) 1106
• Volunteer Since 2007-08-08
• Prestige Points 9790

Recent Reviews from Users

Read More Comments

Recent Answers from Jan Karel Pieterse

2009-11-19 Copying multiple worksheets data and updating:

Hi Fernando, Something like this (paste code in normal module, always make sure your first sheet is active before running the code): Sub CopyInfo() Dim oSh As Worksheet For Each oSh In

2009-11-18 Left Lookup:

I think the easiest way to do this is by using a pivot table. I put a row above the data, with labels "Name" above the names and "City" above the cities. - Select from the menu: Data, Pivot table and

2009-11-17 Multiple currency conversions in Excel 2007:

You could use the IFERROR function: =H13/IFERROR(VLOOKUP(G13;$B$13:$B$19;2;FALSE);1) In that case, the function uses 1 as conversion rate when a currency ins't found. That will avoid errors in

2009-11-16 Multiple currency conversions in Excel 2007:

Hallo Wim, Dutch would have been fine, but indeed, English is best here, so others might learn too. Have a look in Help on the VLOOKUP worksheet function. It will do exactly what you need here.

2009-11-11 comparing two lists and deleting matches:

Hi Timo, A manual way: Assume column A contains unique entries and you want to delete any entries that have a duplicate in column A. Enter this formula in any empty column: =COUNTIF($A$2:$A2