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!


--
MrB1onde
------------------------------------------------------------------------
MrB1onde's Profile: http://www.excelforum.com/member.php...o&userid=37162
View this thread: http://www.excelforum.com/showthread...hreadid=568817