How to compare two columns with other two columns for duplicates in Excel

microsoft-excel worksheet-function comparison
11,892

In E1 you can put

=IF(AND(C1=A1,D1=B1),"exist","")

and drag it down.

Share:
11,892

Related videos on Youtube

PaulB.
Author by

PaulB.

Updated on September 18, 2022

Comments

  • PaulB.
    PaulB. over 1 year

    I need to compare columns C and D with A and B and only if exist same combination of two cells in one row. Hope the image below will explain the situation better.

    Image of example data

    • Raystafarian
      Raystafarian over 9 years
      Do the matches have to be on the same row or can they be on any row in the two columns?
    • PaulB.
      PaulB. over 9 years
      In the same row
  • Tokci
    Tokci about 3 years
    what if order is not same and some values missing ,so this wont apply

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

Excel - comparison of text between two columns
What would be the the mathematical equivalent of this excel formula? =PMT()
Excel - How to create a worksheet that refresh daily and save old info
Combining IF and SIGN functions in Excel
IF/AND statement with three conditions
Calculating Stock Profit/Loss in Excel
How to Link Cells in Column to Cell in Rows
Sum within date range (changing monthly)
excel vba: copy rows if data match with values in column in another sheet
How do I split single cell contents into multiple columns without seperators?