You are here:
Excel and Excel/VBA questions
Excel MVP
Self employed Excel developer
Bachelor in Chemical Engineering
Microsoft MVP award since 2002
Shell, Fortis bank, ABN-AMRO bank, Morgan Stanley, ...
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Wim van Kuijk | 11/18/09 | 10 | 10 | 10 | 10 | Jan Karel's performance and help was astonishing ..... |
| Henk | 11/17/09 | 10 | 10 | 10 | 10 | |
| Timo | 11/11/09 | 10 | 10 | 10 | 10 | Well that was fast! Thank you for ..... |
| Shawn | 11/08/09 | 10 | 10 | 10 | 10 | very helpful,appreciate you |
| Lee | 11/05/09 | 10 | 10 | 10 | 10 | AS easy as that, lol Many thanks |
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
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
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
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.
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
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.