Forum Discussion
Extract shared values between two columns
Hi everyone, I am trying to extract shared values between two columns. I found a post on another website that has a formula to use, but I am struggling to apply it to my dataset. Below is the fo...
Formula assumes your data starts from the second row. You may expand your range with some gap, wrap formula with IFERROR and enter it in C2 as an array formula (Ctrl+Shift+Enter), like
=IFERROR(INDEX($A$2:$A$1100, SMALL(IF(COUNTIF($B$2:$B$1100, $A$2:$A$1100), MATCH(ROW($A$2:$A$1100),ROW($A$2:$A$1100)), ""), ROWS($A$1:A1))),"")
and drag it down till empty cells appear.
Alternative non-array formula could be with AGGREGATE and with using of dynamic ranges, but that's not critical.
| I have data in “A” column and input in “B” column and required result is in ” C” column. |
| I already fond the result is in “E” Column. But this result needs to fix the corresponding raw of the A Column. |