Solved

Matching columns in Excel

Posted on 2014-09-23
2
157 Views
Last Modified: 2014-09-23
I have a 5 column spreadsheet. Column A has 4455 rows of various numbers column B has 6775 various numbers, columns C, D and E contain other data. I want to match column B to column A and align B, C, D and E next to it's matched number in column A and delete the unmatched data from B,C,D and E. Attached is an example spreadsheet.

Thanks!
sample-excel-file.xls
0
Comment
Question by:Justin Moore
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
ID: 40340117
Hello,

I inserted new column B where using VLOOKUP funcion i found values from Column B that existed in Column A... After i implemented filter and deselect #NA numbers i..e those that are not matched to each other.
You can filter those #NA values to delete them...

Attached is the file with new column
sample-excel-file-matched---Copy.xls
0
 
LVL 9

Author Comment

by:Justin Moore
ID: 40340138
Samo - I think this will work. I'm going implement it on the actual file in a few minutes and will let you know but it looks like exactly what i need.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question