Search : in
By :

Comparing and extracting data in Excel

Last answer on Aug 16, 2009 6:36:17 am BST mycojohn, on Nov 25, 2008 11:02:45 am GMT 
 Report this message to moderators

Hello,

I am trying to compare two excel sheets; the first sheet (entire data) contains thousands of rows and 5 columns, the second sheet (search phrase) contains a list of a few hundred reference names that correspond with the names in the first column of the first "entire data" sheet. All of the names on the second "search phrase" list appear only once on the first "entire data" sheet (the entire data set contains thousands of other names that are not present on the second list). I want to automate the process of comparing each name on the second "search phrase" list with the names in the first column of the first "entire data" sheet and where the matching name is found extract the 5 columns related (horizontally) to that name to a new sheet.

Can this be done?

Thanks in advance for any help.

Best wishes,

John.

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « comparing and extracting data in Excel » in :
Comparing two excel worksheets Show
Excel data extraction macro needed Show
Excel – How to extract partial data? Show Excel – How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another...
Excel - Comparing columns and returning value ShowExcel - Comparing columns and returning value Issue Solution Note Issue I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D ...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Download Financial LinK ShowDescription The application is designed XLConsulting. Simple and easy to use, the application has been awarded from various places. It offers an intuitive interface. Financial Link enables you to change your Excel spreadsheet into financial tool....
Download MyDataChameleon Show
Download TxtConv ShowTxtConv is a file conversion utility. As its name suggests, it allows to convert a text format to another. Its main feature is to extract data from a text file in columns. It can rewrite the whole columns or only a part of them by changing their...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
Ask your question Reply

1

katie, on Apr 8, 2009 6:57:02 pm BST
  • +9

Hello, i know you asked this question a while ago but I have a similar situation and Im wondering if you ever got an answer to this. Please please let me know!

Thanks

   
Reply to katie

2

The_Puttycat, on Apr 12, 2009 1:46:00 am BST
  • +10

Hello,
I have a very similar problem as well. Did you ever find an answer? Please reply.
Thanks in advance

   
Reply to The_Puttycat

3

 ALEX, on May 30, 2009 5:41:12 pm BST
  • +4

Try the "Compare 2 lists" program found in the following address: http://sites.google.com/site/compare2lists/Home

   
Reply to ALEX
Ask your question Reply
They need your help