Tag Archives: Mac remove duplicates

Remove duplicates on a Mac (Last occurrence is kept)

Removing duplicates on a Mac is slightly different to on a PC version of Excel. This is more brute force than elegant and may take a little longer, but it does work. ‘Code designed 25/2/2017 by datanology.co.uk Application.ScreenUpdating = False ‘Find last row With ActiveSheet lastrow = .Cells(.Rows.Count, “B”).End(xlUp).Row End With For d = lastrow […]

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group