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
How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Similar threads
