Count the number Unique Items in Excel
By Herve le turdu

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

Get the best prices on the web



  • 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: 343

Test 2 // show category page: Uncategorized