All articles with 'cleanup data' Tag

How do you consolidate data from multiple sheets in to one? [open thread]

Published on Feb 19, 2010 { 19 Comments }
How do you consolidate data from multiple sheets in to one? [open thread]
Continue »

Fix Incorrect Percentages with this Paste-Special Trick

Published on Jan 29, 2010 { 6 Comments }
Fix Incorrect Percentages with this Paste-Special Trick
Continue »

Flu Trends Chart in Excel [Yes, we can edition]

Published on Jan 22, 2010 { 11 Comments }
Flu Trends Chart in Excel [Yes, we can 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 »

Excel Links of the Week [Dec 1]

Published on Dec 1, 2008 { 0 Comments }
Excel Links of the Week [Dec 1]
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 »

Clean up Incorrectly Formatted Phone Numbers using Excel

Published on Sep 30, 2008 { 6 Comments }
Clean up Incorrectly Formatted Phone Numbers using Excel
Continue »