 # Compare the rows and get output excel

Hi ,

I'm trying to get comparison between the 4 rows which are having identical and different values as well, need help on sorting and getting answer please.

Scenario: below in in=mage i have 4 rows where row D and E are set 1, G and H are another set 2

If Set 1 has one name and value which is equal to set then it is fine but if set 1 has value but set 2 is not same then there should be the name D stored in J.

Example: in below image 1 the option Algeria present in both sets with equal values but in in name 2 the Macao SAR is not present in set 2 so added in J row.  8 Replies

# Re: Compare the rows and get output excel

I2=VLOOKUP(D2,G:H,2)=E2
j2=FILTER(D2:D6,I2:I6=TRUE)

# Re: Compare the rows and get output excel

Hi,

Can you please brief this , as i am trying to compare two sets in which all the data is not identical and not same values included in both.

# Re: Compare the rows and get output excel

(1) Column-I is a referecen column. If (D2,E2) have same pairs found in G:H, return true in I2
I2=False means (D2,E2) have no identical pair in G:H
Input formular in I2 (=VLOOKUP(D2,G:H,2)=E2) and Fill Down

(2) Use FILTER to filter column D with rule of column I
J2=FILTER(D2:D6,I2:I6=FALSE)

Or Use Array to skip reference column-I
J2=FILTER(D2:D6,VLOOKUP(D2:D6,G:H,2)=E2:E6)

# Re: Compare the rows and get output excel

The I2 column is returning unique values and there are duplicate As well, the Macao is not present in the set 2 but there is an value # Re: Compare the rows and get output excel

@Ashwin540
You missed "=E2"

``I2 =VLOOKUP(D2,G:H,2)=E2``

# Re: Compare the rows and get output excel

@XXplore  now it gives as False  as below # Re: Compare the rows and get output excel

Looks like your column H is in Text format while column E in General format

# Re: Compare the rows and get output excel

@Ashwin540

=IFERROR(FILTER(A,A&B<>C&D),"")

where:

• A is the range of Original Name
• B is the range of Original Value
• C is the range of Parameter Name
• D is the range of Parameter Value