Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 09-20-2016, 09:08 AM
ShaunO ShaunO is offline Windows 7 64bit Office 2013
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.
Reply With Quote
Old 09-20-2016, 09:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
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 lightPecoflyer is a glorious beacon of light

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

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 11:07 AM.

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