Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-20-2016, 09:08 AM
ShaunO ShaunO is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Aug 2016
Posts: 2
ShaunO is on a distinguished road
Exclamation Excel Searching/Sorting Options

I have two different Excel Files each having two different columns of data, they share one common set of data in a Column. I want to copy and paste and create one file, but sort the file so the common data matches and then extract and match the data linked to it. Please let me know if this doesn't make any sense. I think I am over complicating things as I believe this is probably a common problem. Thanks in advance for any solutions.


Shaun
Reply With Quote
  #2  
Old 09-20-2016, 09:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Perhaps something like a VLOOKUP function?
Eventually post a small sample showing some data and desired results?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Tags
columns, data, sorting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting the Outlook inbox before searching for an email Officer_Bierschnitt Excel Programming 2 11-25-2015 01:14 AM
Urgent help needed: Sorting/searching fields cvrm Excel 2 04-17-2014 05:47 AM
searching for text in multiple excel files roytom Excel 2 07-30-2012 01:57 PM
Sorting larg Excel file cause windows hang tasuooooo Excel 1 07-17-2012 07:23 AM
Sorting columns in Excel - please advise Jonre Excel 2 08-21-2009 02:38 AM


All times are GMT -7. The time now is 02:09 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft