Tuesday, April 9, 2019

Excel Remove Duplicates

For years I've used Excel pivot tables to get a list of values without duplicates, but way back in Excel 2007 a better option was delivered and it has took me until now to hear about the "Remove Duplicates" option, clearly available on the Data tab in the Data Tools section.  Read more at the link on how to handle multiple columns of data.

Shout out to Keith F for this tip!


No comments:

Post a Comment