Taking Column A values comparing to Column B values if they are the same post to Column C-CodePudding

I'm trying to take the names from column A compare them to the names in column B and then have the similar names get listed in column C.

The problem is these names are automatically updated and out of order, and I need the function in column C to update with them. Also, the names will not be in order, this is why I can't use A=B function. The picture shown is an example of what the solution would look like or something similar. After completing this, I would like to continue using the same function to break down the name data even more. Watched a lot of videos on this, can't find anything specific enough to work.

Side note, I have found a way to do this using different pages within the sheets but not in the same sheet side by side.

CodePudding user response：

Try below formula-

=FILTER(C3:C,INDEX(COUNTIFS(D3:D,C3:C))>0)

CodePudding user response：

all you need is:

=FILTER(C3:C; COUNTIFS(D3:D; C3:C))