I have two spreadsheets where one (beta
) contains a subset of rows of another (alpha
). In both spreadsheets, I have a column that is a unique ID for each row. Is there a way to find alpha JOIN beta
? I want to be able to identify each row in alpha
that also appears in beta
. Thanks!
I'm doing this in Google spreadsheets if that helps.