在 Google Sheets™ 的兩欄中尋找重複項

This feature will let you compare two columns in the same sheet (current selection) and highlight values that appear in both.

Planned workflow

Select two columns in the same sheet (equal height preferred)
Run a Compare action to detect shared values
Review a results table with match counts and positions
Apply follow-up actions: highlight, extract, or copy matches