If duplicate account names are listed, click a duplicate account, and then click the minus sign ('-') icon in the lower-left corner or press the Delete key on your keyboard to delete that account. If there are no duplicate accounts, go to the next step. Become a Registered Member (free) to remove the ad that appears in the top post. Click here to reset your password. You MUST have a valid e-mail address so that you may receive the instructions to complete the reset. If this is your first visit, be sure to check out the Board FAQ by clicking the link above.

I've taken a quick screenshot for this. I've selected my data (1). You won't find 'remove duplicates' in the Data menu (from the menu bar). Instead, click Data from the ribbon (2); click Remove Duplicates (3); confirm (4). How to get newer version of microsoft for mac. If you don't see the 'Data' option on the ribbon, then look on the far right of the green ribbon for the cog symbol. Click that, then 'Ribbon Preferences'.

Then you'll get to a customisation page where you can toggle the visibility of different ribbon groups. Hope this solves it.