Book1.xlsb
drive.google.com
Cells are the same in the attched, no spaces. When I retype the numbers I can remove the duplicates, but get an error otherwise: "...cant be applied to selected range..."
Excel 2016
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Remove Duplicates not Working
- Thread starter vllgv
- Start date
drive.google.com
Cells are the same in the attched, no spaces. When I retype the numbers I can remove the duplicates, but get an error otherwise: "...cant be applied to selected range..."
Excel 2016
Excel Facts
Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Similar threads
