Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2016, 09:08 AM
ShaunO ShaunO is offline Excel Searching/Sorting Options Windows 7 64bit Excel Searching/Sorting Options Office 2013
Novice
Excel Searching/Sorting Options
 
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 Excel Searching/Sorting Options Windows 7 64bit Excel Searching/Sorting Options Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps something like a VLOOKUP function?
Eventually post a small sample showing some data and desired results?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
columns, data, sorting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Searching/Sorting Options Sorting the Outlook inbox before searching for an email Officer_Bierschnitt Excel Programming 2 11-25-2015 01:14 AM
Excel Searching/Sorting Options Urgent help needed: Sorting/searching fields cvrm Excel 2 04-17-2014 05:47 AM
Excel Searching/Sorting Options 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft