I have two sheets in the same excel, where I have names of students in column A of both sheets. I need to match which names appear in both the sheets in column A and put that on a different sheet.
For Examaple, suppose I have A, B, C ,F, K , H ,M , L, Y, Z in column A of sheet 1 and have the names of C, M, K, A, J, R, Y, E, D, Q, X in sheet 2, then these two columns should be compared, and then the matching names in both of them which are A, C, K, M, should come up on column A in sheet 3.
Let me know if more details are needed.
For Examaple, suppose I have A, B, C ,F, K , H ,M , L, Y, Z in column A of sheet 1 and have the names of C, M, K, A, J, R, Y, E, D, Q, X in sheet 2, then these two columns should be compared, and then the matching names in both of them which are A, C, K, M, should come up on column A in sheet 3.
Let me know if more details are needed.