Forum Discussion
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...
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.
Your section included I column?
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.
Your section included I column?
(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)
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)