Dec 25 2022 08:42 PM
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.
Dec 25 2022 10:57 PM
Dec 25 2022 11:14 PM
Dec 25 2022 11:36 PM
Dec 26 2022 03:31 AM
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
Dec 26 2022 09:16 PM
@Ashwin540
You missed "=E2"
I2 =VLOOKUP(D2,G:H,2)=E2
Dec 26 2022 09:31 PM
Dec 26 2022 10:25 PM
Dec 27 2022 02:06 AM
=IFERROR(FILTER(A,A&B<>C&D),"")
where: