Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums How to remove common values in Excel under different rows? – MindStick
Ask Question

1 Answers

Aryan Kumar
Aryan Kumar 23 Aug 2023
Report Abuse

There are a few ways to remove common values in Excel under different rows.

Using the Remove Duplicates feature:

  1. Select the range of cells that you want to remove the common values from.
  2. Click on the Data tab.
  3. In the Data Tools group, click on the Remove Duplicates button.
  4. In the Remove Duplicates dialog box, select the columns that you want to remove the duplicates from.
  5. Click on the OK button.

Using the Advanced Filter feature:

  1. Select the range of cells that you want to remove the common values from.
  2. Click on the Data tab.
  3. In the Sort & Filter group, click on the Advanced button.
  4. In the Advanced Filter dialog box, select the Remove Duplicates option.
  5. Select the columns that you want to remove the duplicates from.
  6. Click on the OK button.

Using a VBA macro:

You can also use a VBA macro to remove common values in Excel under different rows. The following is a VBA macro that you can use:

VBA

Sub RemoveCommonValues()

' This macro removes common values in Excel under different rows.

Dim rng As Range
Dim i As Long
Dim j As Long

' Set the range of cells that you want to remove the common values from.
Set rng = Range("A1:B10")

' For each row in the range,
For i = 1 To rng.Rows.Count

    ' For each cell in the row,
    For j = 1 To rng.Columns.Count

        ' If the value of the cell is already in the current row,
        If rng(i, j).Value In rng(i, 1:j - 1) Then

            ' Remove the value from the cell.
            rng(i, j).Value = ""

        End If

    Next j

Next i

End Sub

To use this macro, copy and paste it into a VBA module and then run the macro.

advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md