Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 29 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 32 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JRequest::clean() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 33 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 463 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 464 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 465 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 466 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 467 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 468 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 35 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 38 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 39 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 46 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 47 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 50 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 53 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 54 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 57 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 58 Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: Cannot modify header information - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 426 Ontdubbel je adreslijst in Excel 2007
Notice: Use of undefined constant add_css - assumed 'add_css' in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 49 Notice: Undefined variable: add_class in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 234

Ontdubbel je adreslijst in Excel 2007

Excel logoExcel wordt vaak gebruik om gegevens te bewerken, voor je ze in een dbase of maillijst propt. Je kan lijsten zeer eenvoudig ontdubellen door de geavanceerde filter te gebruiken.

Selecteer eerst de rijen die je wil filteren (bv een e-maillijst)

Klik op het tabblad Gegevens van in het deel Sorteren en filteren op Geavanceerd.

Office excel: tabblad Gegevens

In de uitgebreid filter (taalfoutje van microsoft) selecteer je Kopiƫren naar andere locatie, typ in het vakje Kopiƫren naar $B$1 (dit staat voor plakken in kolom B vanaf rij 1) en vink Alleen unieke records aan.

Geavanceerde filter

Klik op OK en in kolom B staat je lijst ontdubbeld, let wel deze techniek is hoofdlettergevoelig, en soms wordt een naam wel eens fout en daardoor dubbel ingevoerd.

Bureaublad achtergrond afbeeldingen

Laatste

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109

Topbedrijven

Vochtbestrijdingsbedrijf Tibas bvba

Meest bezocht

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79