All articles with 'unique items' Tag

Data Validation using an Unsorted column with Duplicate Entries as a Source List

Published on Feb 2, 2010 { 7 Comments }
Data Validation using an Unsorted column with Duplicate Entries as a Source List
Continue »

Prevent Duplicate Data Entry using Cell Validations

Published on Oct 26, 2009 { 13 Comments }
Prevent Duplicate Data Entry using Cell Validations
Continue »

Count the number of unique values in a range [Quick Tip]

Published on Aug 6, 2009 { 14 Comments }
Count the number of unique values in a range [Quick Tip]
Continue »

Remove Duplicates [Quick Video Tip]

Published on Jun 22, 2009 { 2 Comments }
Remove Duplicates [Quick Video Tip]
Continue »

Using Array Formulas in Excel – Find if a list has duplicate items

Published on Mar 25, 2009 { 21 Comments }
Using Array Formulas in Excel – Find if a list has duplicate items
Continue »

Excel Links of The Week – Malmo Edition

Published on Mar 23, 2009 { 5 Comments }
Excel Links of The Week – Malmo Edition
Continue »

One more method to find unique values in excel and you can call me a dork

Published on Feb 3, 2009 { 23 Comments }
One more method to find unique values in excel and you can call me a dork
Continue »

Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]

Published on Nov 6, 2008 { 2 Comments }
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Continue »

Excel Links of the Week [Nov 3]

Published on Nov 3, 2008 { 1 Comment }
Excel Links of the Week [Nov 3]
Continue »