How do I remove duplicates from an array in Excel?

Table of Contents

In Excel, there are several ways to filter for unique values—or remove duplicate values:

Exercise Workbook:

STEP 1: Go to Developer > Code > Visual Basic.
STEP 2: Paste in your code and Select Save. Close the window afterwards.
STEP 3: Let us test it out! Make sure to have your cells selected. Open the sheet containing the data. Go to Developer > Code > Macros. Make sure your macro is selected. Click Run.

How to duplicate a sheet in Excel with VBA?

Now to go VBA and write subcategory again of VBA Remove Duplicates. We have given the sequence to each code we showed to have a proper track.

This is quite a similar pattern which we have seen in example-2 but a shortcut way to write a code for removing duplicate.

Now select the RemoveDuplicates command as shown below.

How to access and enable VBA in Excel?

Disable all macros without notification Macros and security alerts about macros are disabled.

Disable all macros with notification Macros are disabled,but security alerts appear if there are macros present.

Disable all macros except digitally signed macros Macros are disabled,and security alerts appear if there are unsigned macros present.

How do I use VBA in Excel?

Select the Developer Tab. Click on Insert and select the first option from ActiveX Controls.

Drag the arrow at any cell to create a Command Button.

To enter the OFFSET function,right-click on the Command Button and click on View Code.

Inside this function,we have to write our code of OFFSET for selecting cells.

Now,go to VBA and from the Insert menu,add a new Module.

Now consider a dimension Rng as Range,InputRng as Range and ReplaceRng as Range. You can choose any other letters or words for defining ranges.

Now,use xTitleId as dialog box and give it a name.