Count the number Unique Items in Excel

I have stumble upon the only way to calculate the number of unique items in Excel and I am taking notes here

Add a column to the database and then add that field to the pivot table.

For instance if we want to count the unique occurrences of URL/Keyword, we shall add in the raw data:
- the row URL/Keyword in the raw data.
- In the first data row, enter a formula that refers to the URL and Kws columns. For example:


Copy the formula down to all rows in the database.
Then, add the field to the data area of the Excel pivot table.

source: Pivot technics

Google Farmer update in the UK

Has Sunday been a sunny day in the UK or has the Panda Google’s update already stricken? Crawl rates show that the bots are done indexing the UK sites. It should be a matter of weeks. Any thoughts ?

symfony on wamp

symfony propel-build-model wamp error due to XSL extension

Description:   I was trying to run the symfony PHP framework. I tried to build the model using command
php symfony propel:build-model.

And it gave error Could not perform XSLT transformation. Make sure PHP has been compiled/configured to support XSLT.

Environment: Wamp server 2.0, PHP 5.2.5, Apache 2.2.6.

Reason: PHP-XSL extension is not enabled. By default, Wamp server doesnt enable php-xsl php extension. and php-xsl is required.

Solution: Enable php-xsl extension.

left click on WAMP’s tray icon and than in PHP>PHP extensions select php-xsl and enable it.But there is one more php.ini file, which WAMP won’t change, we need to do it by hand, open: C:\wamp\bin\php\php5.2.5\php.ini and remove “;” from the line xsl.dll

Install the pear packages you ll need for your crawler

Once PEAR is installed on your server.

Install Net_URL 2:

cmd > pear install Net_URL2-0.3.0

Install HTTP_Request2-0.5.1

cmd > pear install HTTP_Request2-0.5.1

Number of backlinks of a domain

There is a redirect on the URL you want to measure the number of BL with SEO quake : problem

Use the yahoo BL capabilities by searching :

note: use as many -site: as needed to remove sidewides links

Installing pear on WAmp


Command: cd c:\wamp\bin\php\php5.3.0

Command: go-pear.bat

French version (

IF IT DOESN’T WORK if you are using php5.3.0 so you have refer to

1) Locate the “php.ini” file.  In my case, I found it at this path:


Don’t use the WAMP system tray icon to edit this file. It didn’t work when I tried – you have to manually locate it.

2) Find the following line, in bold:

;phar.require_hash = On


;phar.require_hash = On

3) Uncomment the “;phar.require_hash = On” line by removing the semi-colon.

4) Change “On” to “Off”.


phar.require_hash = Off

Fill in the fields. Done

ADD the Pear variable in your environment variables and check that the include_path=”.;c:\wamp\bin\php\php5.3.0\pear”

is in both of Wamps php.ini located at c:\wamp\bin\php\php5.3.0\php.ini and C:\wamp\bin\apache\apache2.2.11\php.ini.

Restart your computer

Installing the http_request package:

pear install Net_URL2

pear install HTTP_Request2-0.4.0 => install ok



  • My twitter:

Test of NS:

I will try to insert different elements into it:

Broken TWiTTs :(



  • Hervé Le TurduMy name is Herve Le Turdu.
    I am a 32 years old french* man with an inquiring mind and an enthusiastic personality. Get to know me better !

    *Pardon my English tainted with a strong accent and of many mistakes

Projects & Work

LINKS - BeCause they deserve it!

I Love SEOgadget ----------------------------------------------------
Testing stuff:

Test 1 // show post ID: 130

Test 2 // show category page: Uncategorized