How to compare data in 2 columns in Excel and then in one cell, determine if there are similar data in both columns
Posted
by
Charmaine Camara
on Super User
See other posts from Super User
or by Charmaine Camara
Published on 2012-03-16T06:14:13Z
Indexed on
2012/10/06
9:40 UTC
Read the original article
Hit count: 251
microsoft-excel
I have 2 columns in Excel: the first contains a list of employee names who perform function A, and the second contains a list of employee names who perform function B.
What I want is to identify, in one cell, if there is one employee whose name appears in both the first and second columns. It does not have to show which name(s) appears in both columns, it just needs to identify IF there are any names that appear in both columns.
© Super User or respective owner