Scenario: 2 Excel columns with a large number of data. We need to filter out or find only the common values which is available in both columns.
For finding common values
Type this formula in the 3rd column
=FILTER(1st column data range,COUNTIF(2nd column data range,1st column data range))
Example:
Using this formula we can filter out the common values