Stuck on combining two lists with different column headers

[MrB1onde]

Hi All,

I have searched far and wide for a solution to my issue, but hav
yet to come upon one. Here's my situation. I have two lists, eac
containing ~1,500 items. The column headers are as follows:

List #1:

Column A: Usernames (ie Smith)

Column B: Locations (ie Dallas)

List #2:

Column A: Usernames

Column B: Site hits (ie 38)

From these two lists, I want to extract the duplicat
entries(these are the entries in which I am interested) based on th
Username field. So basically I want to create a single list lik
this:

Column A: Usernames (all Usernames common to both lists)

Column B:: The location associated with each particular Username

Column C: The number of site hits associated with each particula
Usernames


I have found plenty of references to extracting duplicate entrie
from two lists, but none where the lists had different column headers.
Any help would be greatly appreciated. Thanks in advance

 

[mrice]

You could try using the COUNTIF function for each entry in the two lists
to see which occur in the other list (i.e. having a count of 1). These
could then the sorted to get the common entries into a block. You could
then use a VLOOKUP function to bring together the two sets of data.
Alternatively, if you have absolutely no duplication within each, you
could get away with sorting each list's common entries by username and
then just line up the other two columns.