00:00In a comment section of one of my videos someone inquired how to compare two tables and return a
00:04common value in a separate column. This is how I would do it. In my table here I got table A
00:09and table B. I'm looking for common names here. So I'm going to use equal filter. The first argument
00:16would be from table A all the student name and then the second argument I'm going to use count
00:22ifs and in there I'm going to use table B's student name like this and then comma I'm going
00:28to compare with table A's student name like this and close parenthesis close parenthesis
00:33and hit enter and this will give you all the repeated names which is in table A and table B
00:38but if you also want the test result next to it all you have to do is to change
00:42formula here from A to include B as well and hit enter it will return the test result as well.
Comments