Help please with 3 columns of tags(text) that I need to know which tags are comm

[5551scj]

What the problem is:


3 columns of tags(text or alpha-numerics) in which I need to know the tags that are common to all 3 columns.

The rows of each column are not aligned similarly in the horizontal (or X cooridnate axis).

Then display the actual tag values in a different column.


Will be happy to post the spreadsheet.


And, last but never least, Thanks Very Much for any and all assistance!

 

[Luke M]

Would you mind posting a sample of what youre data looks like? I got a little confused by your description as to where things are at.


See link for info on posting snippets of workbook, or for posting entire workbook:

http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[SirJB7]

Hi, 5551scj!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Give a look at this file:

https://dl.dropbox.com/u/60558749/Help%20please%20with%203%20columns%20of%20tags%28text%29%20that%20I%20need%20to%20know%20which%20tags%20are%20comm%20%28for%205551scj%20at%20chandoo.org%29.xlsx


Just advise if any issue.


Regards!