comparison of 2 lists

[elleder]

I would appreciate help with the following problem:

I have two long lists of data in Excel table, numbers or names. I need to select only those that are common to both lists. Is there a way how to do it fast in Excel, or do I need to write a program in VBA?

Daniel

 

[shajueasow]

Welcome to the board
Will this link help you:

http://www.mrexcel.com/board2/viewtopic.php?t=236517

 

[Aladin Akyurek]

I would appreciate help with the following problem:

I have two long lists of data in Excel table, numbers or names. I need to select only those that are common to both lists. Is there a way how to do it fast in Excel, or do I need to write a program in VBA?

Daniel

http://www.mrexcel.com/board2/viewtopic.php?t=228813

 

[elleder]

great help



Solved, thank you!