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:

 
  =IF(SUMPRODUCT(($A$2:$A2=A2)*($C$2:$C2=C2))>1,0,1)

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

http://www.6ma.fr/tuto/symfony+avec+wamp-456



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 : linkdomain:SITE.com -site:SITE.com

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



Installing pear on WAmp

TRY

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

Command: go-pear.bat

French version (http://www.6ma.fr/tuto/installer+pear+avec+wamp-455)

IF IT DOESN’T WORK if you are using php5.3.0 so you have refer to http://blog.pear.php.net/2009/07/01/php-53-windows-and-pear/

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

C:\wamp\bin\php\php5.3.0\php.ini

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:

; http://php.net/phar.require-hash
;phar.require_hash = On

; http://php.net/phar.require-hash

;phar.require_hash = On

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

4) Change “On” to “Off”.

; http://php.net/phar.require-hash

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



RECENTLY BLOGGED ABT

TWEETS

  • My twitter:

Test of NS:

I will try to insert different elements into it:

Broken TWiTTs :(

  •  

AUTHOR

  • 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:
http://leturdu.com/uncategorized/

Test 1 // show post ID: 130

Test 2 // show category page: Uncategorized