asked on Excel two column compare
Greetings,
I read the post: https://www.experts-exchange.com/questions/28903591/Compare-two-columns-in-Excel-for-string-comparisons.html?anchorAnswerId=41381690#a41381690
I have two tables on the same page where I am wanting to compare the first column of two tables (columns B & H) and want to output to column M with value matches. The gist: Table 1 has the users listed my manager wants to target and Table 2 has a larger list of all domain users with various other columns with data about each user. I am essential trying to 'go fish' for the users in the big list.
The purpose of the output is to allow filtered table view (the gi-normous table) showing only the users from the small table.
Thank you!
I read the post: https://www.experts-exchange.com/questions/28903591/Compare-two-columns-in-Excel-for-string-comparisons.html?anchorAnswerId=41381690#a41381690
I have two tables on the same page where I am wanting to compare the first column of two tables (columns B & H) and want to output to column M with value matches. The gist: Table 1 has the users listed my manager wants to target and Table 2 has a larger list of all domain users with various other columns with data about each user. I am essential trying to 'go fish' for the users in the big list.
The purpose of the output is to allow filtered table view (the gi-normous table) showing only the users from the small table.
Thank you!
Microsoft Excel
Last Comment
Professor J
You've posted this same question at least 13 times in the last half hour.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hey folks,
I have had some major system problems...it seems somehow I have posted multiple times. My apologies; working on the issues now :)
I have had some major system problems...it seems somehow I have posted multiple times. My apologies; working on the issues now :)
No problem. When I got the multiple notifications I "Requested Attention" so a moderator will clean them up. Or you could delete the others if nobody has responded to them.
John, i have provided you with a possible solution, please check let me know how it goes.
ASKER
Thank you PJJ! I will look now!
ASKER
Martin, I goto my past questions and I don't see multiples; maybe they have already been force closed?
Yes, I agree.
ASKER
Thank you, again! You're a life saver!
You are welcome John.