Hi All,
I have searched far and wide for a solution to my issue, but have yet to come upon one. Here's my situation. I have two lists, each 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 duplicate entries(these are the entries in which I am interested) based on the Username field. So basically I want to create a single list like 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 particular Usernames
I have found plenty of references to extracting duplicate entries from two lists, but none where the lists had different column headers. Any help would be greatly appreciated. Thanks in advance!
Bookmarks