How to catch, sort and separate duplicate values in Microsoft Excel
I was working on an excel sheet with over 10,000 values in which there were multiple duplicates, triplicates and used this method to help me sort the duplicates/triplicates. The first thing was to do is to select the entire column and select duplicates as show in fig 1 fig 1 Click on duplicates … [Read more…]
