Forum Discussion
Ashwin540
Dec 26, 2022Former Employee
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...
XXplore
Dec 26, 2022Brass Contributor
I2=VLOOKUP(D2,G:H,2)=E2
j2=FILTER(D2:D6,I2:I6=TRUE)
j2=FILTER(D2:D6,I2:I6=TRUE)