# How Do You Sort Columns So That They Match Up With Other Columns With Like Data

Jul 2, 2008

I have two columns one is web addresses and the other is email addresses but the rows do not line up. I was hoping that since the second half of the email address matches the web address I could somehow sort them so that the email address column and web address column match up. Here is an example but keep in mind that this list is about 9k long and this is just a sampling so you may not see any in this example that match. Also I may have more than one email address per website.

## Match And Sort Data In 6 Columns?

Jan 6, 2014

Column A has donor name, column B has corresponding donation data for 2011. Column C has donor name, and column D has donation data for 2012. Column E has donor name, and column F has corresponding donation data for 2013.

Although Columns A and C and E all have donor names, there are many changes
from year to year with the addition and deletion of certain donors so the rows do not match up exactly. Is there a quick way to have the rows match up according to donor names in column each of the three columns? Secondarily, I need to sort by donation amount from highest to lowest (it can either be the total over the three years or based on any single year.

Currently my list looks like this:
2011 2012 2013
A A A
B C B
D D C
F E D
H F I
L G K
M H M

I would like it to look like this:
2011 2012 2013
A A A
B - B
C C -
- D-
- E-
F F F
G G G
H - -
L - L
- - M

Basically, I want to see the year over year giving for each donor. I've attached a sample for refrence. (I can't post the original due to confidentiality requirements.)

## Sort And Match 2 Columns Of Data

Jul 19, 2012

I have 3 columns of data and 30,000+ rows. Column A & B are related and column C contains some of the same values as column B but not an exact match. I'm looking for a way to sort columns A & B so that columns B & C match up and the data from column A is moved as well. For any data that has no match, a blank space should be input. Please see below.

A B C

red dog cat
blue cat dog
green mouse pig
yellow horse kitten

A B C

blue cat cat
red dog dog
green mouse pig
yellow horse kitten

## (Match & Sort) Sort Columns B And C So That A And B Match Up Numerically

Feb 26, 2009

I would like to sort columns B and C (keeping the two lined up together) so that A and B match up numerically.

## Match And Sort By Two Columns

Feb 4, 2010

Column A has customer name, columns B,C,D has corresponding sales data for
that month. Column E is blank. Column F has has customer name. Column
G,H,I has the same corresponding sales data for the next month.

Although Column A and F both have customer names, there are many changes
month over month with the addition and deletion of certain customers so the
rows do not match up exactly. Is there a quick way to have the rows match up
according to customer names in column A and F and then sort them
alpabetically?

Currently my list looks like this:
Jan Feb
A A
B C
D D
F E
H F
L G
M H

I would like it to look like this:
Jan Feb
A A
B
C
D D
E
F F
G
H H
L
M

## Subtracting 2 Columns Of Data From Each Other When Labels In Separate Columns Match

Feb 20, 2009

I have four columns of data, as follows:

label 1, value 1, label 2, value 2

I need to create a formula in the fith column that for each line will tell excel to:

look for entry in 'label 1' in 'label 2' if there is a match, then subtract value 1 from value 2, display result.

I have tried doing this with SUMIF but am getting nowhere fast....

## Sort Multiple Columns, With Blanks, And Move All Columns Into One

Feb 15, 2010

I found this code on Ozgrid to sort all columns of a worksheet that were continuous with no gaps or spaces that works well:

Sub CopyToA()
Do While ActiveCell <> ""
Range(ActiveCell, ActiveCell.End(xlDown)).Cut Destination:=Range("a65535").End(xlUp).Offset(1, 0)
ActiveCell.Offset(0, 1).Select
Loop
End Sub

However, I've tried to manipulate the code myself to 1) find all columns that aren't empty then 2) sort each column individually (WITHOUT expanding the sort to other columns) and 3) combining all the numbers into one seperate column. There are many posts concerning sorting but not one that addressed this particular situation.

## Getting 15 Columns In Spreadsheet To Sort On One Columns As It Alphabetizes

Jun 10, 2014

Have a spreadsheet with 15 columns. In one of the columns is the name of the company and that column is not in alphabetical order. The city, state, zip code, business type and all the other pertinent data about that company is in the same row as the name of the company. My intent would be to put the company names in alphabetical order and keep all the company information in the same row as the company name.

## Sort Data Over Multiple Columns

Nov 6, 2009

I'm trying to figure out a way ( excel 2000) how to sort data over a range of columns.

Attached is a sheet.

So what I am looking for is this:

Bottom 10 for target 1, target 2, target 3.

I can sort them indervidually, but is there a way to sort the all?

Or would I need a agent column for each target to sort?

Or maybe there is a way to sort the data so it would work out that if they are in the bottom 10 of lets say 2 of the targets but not all 3 they would still show in the bottom 10?

## Merge And Sort Data Across Columns?

Dec 19, 2012

So I have several columns of data that have a location and then some numbers after it in additional columns. I need to be able to sort it so that all locations that are in both location columns are sorted first, and then any locations that are in one column but not the other column follows. Also the data associated with each column that follows the location needs to remain next to the location. Many times the columns will be of highly disportionate lengths too.

I've attached an HTML table so you can get an idea of what I am looking at, except what I'm dealing with is like.... hundreds of cells long.

I want to be able to turn this:

HTML Code:

<table border="1" bordercolor="#FFCC00" style="background-color:#FFFFCC" width="100%" cellpadding="3" cellspacing="3">
<tr>
<td>A</td>

[Code].....

And in this 6 row example, I'd actually only be interested in the 4 letters that were in both columns. If it makes it easier, I would be okay with discarding the last rows, but would rather just have them sorted at the end, so I could check if....for example there were two different spellings of the same thing, and they should actually be included.

## Sort Different Tab Along With Data Except Columns With Formulas?

Apr 4, 2014

i have a data entry tab where we put names and button to sort and hide blank rows from other tabs. Problem i want to move down the number entered also. something like extend sorting but not affecting the formula on the other columns.

## Sort Pasted Data Into Specific Columns

Jul 2, 2014

how to sort data pasted from word into specific columns e.g.

I paste: 1,2,3,4,8 into the ref row, and it poulates as such, leaving out the columns for which there is no corresponding value:

Competency: 1------2--------3-------4------5------6------7------8
Ref: -------WR1----WR1----WR1-----------WR5------------------WR1

## Sort Repetitive Data From Rows To Columns

Jun 23, 2006

I have a column of repetitive data:

BLANK CELL
NAME
CITY, STATE ZIP
BLANK CELL

I would like to be able to resort the dats so that each line becomes a column
BLANK CELL NAME ADDRESS CITY, STATE ZIP BLANK
CELL

I know I can do it 3 cells/rows at a time using the paste special and
transpose command but I have a 1000 names and addresses. How do I do it in
one operation instead of a thousand?

## VB Macro - Sort Data In Columns Within Active Spreadsheet?

Feb 12, 2014

I am new to VB Macro creation and I am creating VB Macro which will:

1. Sort data in Columns within an active spreadsheet

2. Create new Worksheets

3. Delete Values in rows based on value in Column.

I have listed my "Step by Step" instructions in the tblTest Excel file on attachment. The instructions are clear and straight to the point.

Below are some VB Macros I was experimenting with but it is not complete.

'Sorts a worksheet in ascending order and assumes there are headers on the data
Range("A1:DZ20000").Sort _

[Code].....

## Data Does Not Match Between The Columns

Feb 1, 2007

I have a worksheet that has four columns. FName LName FName1 LNanme1. The data doe snot match between the columns... but I need to know which are in both columns.

I need to write a formula that will allow me to compare the LName with LName1 and give me some type of indication there is a match (1, yes, etc.). Ideally, after confirming there is a match, It would create another verification that FName and FName1 also match, but that is not necessary.

## Match The Data In Two Columns.

May 22, 2009

I basically have a list of 4000 names in one column (A) and an extract from a report containg 26000 names, again in one column (B). I need to see which of the 4,000 names in (A) appear in the column (B) from the report.

How can I do something to either line up the names, or make them change colour or something so I can see the matches?

## Match Up Data From 2 Columns?

Aug 30, 2013

I am trying to match up data from 2 columns and then take data from an adjacent column. I.e. take info in cell 2B, search column D for the same data and grab the data (qty) from the adjecent cell (E).

## Copy Columns Between Worksheets If The Columns Don't Match

Jun 7, 2006

I have 2 worksheets in which I have to copy one column of cells from one to
the other. The problem is that the "main" worksheet lists nearly 3,500
clients and I have to copy numbers into the "main" worksheet on weekly basis
from another worksheet that lists only about 1,100 of those 3,500 clients.

Both client lists are in alphabetical order, but I obviously cannot just copy
one column into the other, because then the numbers won't be matching the
correct clients.

## Match 2 Columns To 2 Seperate Worksheet Columns

Sep 11, 2006

Now i have one excel sheet with two separet sheets in it ( Sheet 1 ) and ( Sheet 2 ) . I have in sheet 1 a column A with material codes and ColB is discreption and Col C IS Prices . But in Sheet 2 Col D is materila Code and Col I is a price .

the recordes in sheet 1 are around 11000 but in sheet 2 are around 2200 where the sheet 2 has a specific materials from sheet 1 .

Now i want to update the prices in sheet 2 from sheet 1 for each item after confirm that the materila code in sheet 2 equal in sheet 1 so copy the price from sheet 1 to sheet 2

Sheet 2 is old prices and sheet 1 has new prices so i need update the new prices in sheet 2

## Match 2 Columns To Copy Information In Other Columns

Apr 21, 2007

I have 2 workbooks (workbook1 & workbook2). Information in column A and column N must match both workbooks per row/ cell (ie. if A2 and N2 in workbook1 match workbook2, copy information from 3 other columns (S, T, U from from workbook1 into workbook2 - cells S2, T2, U2). Workbook2 may have information in column S, T, U, but I need to over-write it with the information from workbook1. If the information does not match per that row/cell (ie. A2 in both worksheets are the same, but N2, they are not, so go to the next line that does match and copy the information into worksheet2). I do not want to use a V- lookup for this problem. I really need a marco.

## Sort Different Columns Separately And Create Combobox To Filter Data?

Jun 6, 2014

I have a workbook has a "Summary" worksheet. I would like to be able to do the following:

(1) Sort columns D, G, J, M,... (the number of columns are different each time I run the macro that I have).

(2) create a combo box to be able to the data (that sorted in 1) by month (1,2,..., 12).

see the attached file

## Match Data From 2 Columns And Then Return Value From A 3rd One

Oct 4, 2008

1. i am comparing text
2. i have >100 countries, and with vlookup i have to type every single one, and this is what i want to escape (mb i need to refer to an array, or string, or no idea)
3. mb a solution could be sth with index, or match, i just tried it, copying some similar formula from www, but it didn't match the countries, and return the value respective for that country.

E.g. I have China in col1 (1st file), #employees 10 in col2 (1st file), and China in Col 1 in 2nd file. So, a formula should match China & China from both files, and return 10 as number of employees.

## Match Two Columns To Data Table

May 28, 2009

I have a volumes sheet and based on two criteria (in columns) am trying to pull the corresponding value from the April Results Table. I have product type in C2 (this varies down the column) and depot numbers in D2. The table i am trying to match has depot numbers in column A2:A93, and Product type in Row 2 (B2:P2), where the two criteria are matched, i need it to return the corresponding figure. I have tried various combinations of Index and Vlookups but i cant get it to work!

## Match Data Across Multiple Columns

Dec 6, 2007

I wish to add more criteria to the "Find Feature to Find 3 Matching Criteria in 3 Columns in Excel" (http://www.ozgrid.com/VBA/advanced-find.htm) up to 7 criteria if possible. How can I do this? I wish to display the results in a dialog box or in a different sheet. I also want to run the find feature from a different worksheet, perhaps using a button instead of having to make a selection in the table.

## How To Match Data Patterns Across Multiple Columns

Apr 14, 2009

I am using Excel 2007 and I need to search for data patterns that are spread across many columns. I am not sure how to search so that criteria is met across all the columns concurrently.

For example

I am interested in data that matches the following criteria ;

Column B has the value 55
Column C has the value 70
Column D has the value 80

Rows of interest are when all the criteria in columns B,C,D are met at the same time (e.g 55 in B, 70 in C and 80 in D).

## Move And Sort With One Column But Insert Extra Columns As Needed For Proper Sort?

Jan 13, 2014

Using DataEntry sheet for data.
Trying to rearrange the data to DataFormatedProperly sheet.
So far all I can accomplish is DataFormatedWrong sheet.

Edit: Not sure what happened but file was NOT understandable before. It should be correct now.

## Match And Align Data In Excel Columns And Rows?

Aug 21, 2013

In an Excel sheet; I am trying to match and align data in column C to data in column A, but it is essential that the data contained in the entire row (coln B thru to coln W) moves when Column C is matched and aligned with column A.

Sample workbook attached.

## Formula To Look At Data In Multiple Columns And Check For A Match

Nov 15, 2012

Any formula that can look at the data in multiple columns and check for a match - returning a value such as YES or NO. Below is an example of my sheet.

A
B
C
D
E
F
G

1
Name
Number
Name
Number
Name
Number
Match?

[Code] ..........

Basically the formula would be in Column G and would look at B, D, & F to see if they match or not. In the example above - row two - they all match. So a True, 1, or Text option such as YES would be great. Same as row 3 only you can see they are different.

## Find / Match Data From Columns And Copy Value To Column 4

May 25, 2013

I am going to explain the issue with a photo linked below

Capture2 | Flickr - Photo Sharing!

Basically i want to match data from column one with data from column 3 if true then copy the data in column 2 to columns 4 in the same match row.

## Auto-Merge Dates In 3 Columns And Then Auto-sort Merged Columns

Jan 10, 2012

I have dates values in 3 columns.

A1 - Header - "Holidays in XXXX'
B1 - Header - "Holidays in YYYY'
C1 - Header - "Leaves by YOU"

A2:B11 have static dates consisting of 10 dates in each column.
C2:C11 - the user may enter any date at any point of time.

I would like to auto-merge the dates in all the 3 columns (A2:C11) in a single column say D2:D31 and then the system should auto-sort the column based on dates in any one order. So as soon as the user enters a value in say cell C2, all the 10+10+1 dates should get sorted.

Also the constraint here is a user may not apply all 10 leaves at in a year. So many of the cells may have blank values.