Re: Count the number of duplicates in a range and then create a ranked sort using VBA
In excel 2007, there is readymade menu command:
Select the data columns
menu -> data-> remove duplicates
This will remove the duplicates for you.
If you have many columns . just select all columns , so the unique is compare all columns,
If you select only one column, the unique is compare only one column.
Why need to write codes for things available easily in excel.
Hope you enjoy this.