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:

 
  =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

Get the best prices on the web



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/2011/09/count-the-number-unique-items-in-excel/

Test 1 // show post ID: 343

Test 2 // show category page: Uncategorized