LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default List equivalent data from two columns

Hi,
Look into CPearson web, scroll down a little to where it says Extracting
elements common to two list

http://www.cpearson.com/excel/ListFunctions.aspx

hope this helps

"Ana" wrote:

Hello,

I have a question for you; could you please help?
I have column A with 300 names and column B with 7000 names.

I would like to list the names in column A that are also in column B.

Is there a function/macro that could do that?
Thanks,
Ana

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dependent list in data validation - more than 2 columns YY san.[_2_] Excel Worksheet Functions 5 March 22nd 09 05:24 PM
Finding & Replacing a list of Data in Multiple Columns Me Excel Worksheet Functions 1 May 5th 08 10:21 AM
Macro (or equivalent) to display certain pivot table data Becky Excel Discussion (Misc queries) 8 May 21st 07 07:40 PM
Convert irregular data to monthly equivalent? RBW Excel Discussion (Misc queries) 3 April 2nd 06 07:50 PM
data validation list from two columns otinky Excel Discussion (Misc queries) 1 March 21st 05 01:13 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"