Excel read duplicate rows and compare columns data to those rows

Help Studio
, ,
1

How In excel read duplicate rows and compare if the columns data of those rows are equal or not

2

@brettthompson
welcome back to the forum

are you looking for approach to detect duplicated row by

  • checking all columns
    Or
  • checking 1 or particular columnset
3

Checking Column A for duplicates which will have multiple sets of them. Then for each set compare the data of specific columns of those duplicates

4

find some starter help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (9.3 KB)

as it using the groupby approach also get some introduction on this here:

5

Hey Brett,

I am not sure I understand exactly what the goal is. Can you provide example data for what the end goal is?

I thought you might be able to use the Dt.DefaultView.ToTable(True, “ColumnName1”, “ColumnName2…”) This will output a dt of only unique values with the specified columns. I am uploading a demo of this in use. Hope this helps…

Dt_DefaultView.zip (2.7 KB)

7

Inventory Reconciliation Monitoring Report (6).xls (692 KB)
find duplicates in columnA and then compare the data in columns F and K and determine if they are equal or not