Multiple Column Sorting

Mar 10, 2009

I'm trying to merge two or more tables.

The first column of each table is the same field, for example 'Country'. Lets say the first table has information on male population, the second table has information on female population. So i want to merge the tables into one, but here's the problem: table1 has 100 rows (countries), table2 has 96 rows (countries). I need excel to recognise the 4 missing rows of data in table2 and insert blank rows so all the data in table2 corresponds to the correct country in table1 (column1).

Here's a (very) simple example: ...

View 14 Replies


ADVERTISEMENT

Comparing And Sorting Multiple Column Groups?

Feb 28, 2014

I'm am trying to take multiple column-groups and sort them by product ID number.

I am trying to put together a sales record for the past 26 months for around 2000 different items and sorting them manually would obviously be a nightmare.

I would like to sort them so that all the drugs with the same NDC (prod ID) have the correct data for each month displayed on the correct row for that NDC. Right now I have each set of data for that month sorted by product ID number but some months we used certain products and others we did not. Is there any sort of Macro that I could use? What I am trying to do I attached two files. The "before" and my desired "after".

starting point.xlsx
end product.xlsx

View 1 Replies View Related

Sorting One Giant Column Into Multiple Columns Based On Cell Color?

Sep 3, 2013

I was handed a pdf of some leads by a co-worker. Finally, I got the data into excel but it's in a pretty useless format... 30,000 rows of contact info with no rhyme or reason. I want to upload this into our CRM, but I need to get all the different bits of info into separate columns. I'm no excel pro, but I managed to use an Excel plugin called ASAP tools to bring some order to this chaos... All names have a blue cell color, all titles have a green cell color, work phone is red, and so on.

Does anyone know a way that I can sort these into separate columns? I've trying playing with the Filter function, but it hides rows which makes the output useless for my purposes.

View 1 Replies View Related

Sorting One Column From A Table Using SUM Totals In That Column

Mar 10, 2014

Basically i have 2 tables like the ones below:

Name Rd1Rd2Rd3Rd4Rd5
Zac 8
James 6
John 8
Frank 4

Name Total
Zac
James
John
Frank

Now i want the total column in the second table to update and add the numbers as i update the rounds in the first one Which i can do through SUM or SUBTOTAL. However i want to sort the total column so the highest number is at the top and everytime i do it changes the name column not the total column.

View 7 Replies View Related

Sorting Multiple Columns ...

Sep 3, 2009

I have a potential of 5 columns of numerical data (simple number entries) which are entered manually in no particular order.

Is there any way of sorting the data so that it is presented in numerical order (smallest to largest) starting with the smallest figure at the start of column 1 up to the largest figure at the end of column 5.

View 11 Replies View Related

Sorting With Multiple Decimals

Jun 11, 2009

I'm looking for a way to sort things with multiple decimals (version number). Is there a way to have something like this:

1.1
1.57
1.1.5
1.2
1.68.23
1.23.1

become:
1.1
1.1.5
1.2
1.23.1
1.57
1.68.23

I could do it all manually, but I have to work with like 400 entries at a time.

View 4 Replies View Related

Selecting Multiple Row For Sorting

Dec 23, 2008

I am trying to select multiple rows so that i can sort. The code i have

View 2 Replies View Related

Multiple Cell Sorting

Jul 9, 2008

I have a multiple Excel sort option question and I hope that someone can answer it. I have multiple rows and I want to sort rows together that match(text or value) in 3 different columns. If there is not a match, I would like Excel to delete the row. I have over 160,000 items and probably only 20,000 match and this is why it would be such a pain to do this manually.

View 9 Replies View Related

Sorting Multiple Columns

Sep 8, 2008

How do I sort multiple columns at once? In other words, I have a chart that is a series of 1s and 2s, and I need all of the 1s to drop to the bottom, so that I can do a rudimentary chart in spreadsheet form. My chart has dozens of columns like so:

1 2 1 1 1 2 2 2 2
1 2 1 1 2 1 1 2 2
2 1 2 2 2 2 2 2 2
1 1 1 2 1 1 1 1 2

How do I get the entire range sorted to look like this, without having to do each column individually (hours of work)?:

2 2 2 2 2 2 2 2 2
1 2 1 2 2 2 2 2 2
1 1 1 1 1 1 1 2 2
1 1 1 1 1 1 1 1 2

View 9 Replies View Related

Sorting A Column

Jan 31, 2008

I have a column which represents by each cell value's number the priority of each row in the table.

What I need to do is create an embedded code that updates the numbers in that column when any value in that column is changed.

For example:

Where the cell values in the column are..

1
2
3
4
5
6

and we change the fifth cell's value to 2

1
2
3
4
2
6

now there are two cells in the column with the same value, we want to keep the value we just changed in the 5th cell but update every other cell that is following the value of 2....

1
3
4
5
2
6

then I would like to resort the table by these new priorities.

similarly if the change is to increase rather than decrease the priority value...where the 3rd cell was increased from 3 ...

1
2
3
4
5
6

changed to 5..

1
2
5
4
5
6

the new change would become...

1
2
5
3
4
6

in this case the 4 becomes 3 and the previous 5 becomes 4 which keeps their relative place in the priority ranking.

I would like this to then resort the table based on this column.

I would like this to execute on the exit of the cell when a cell in the column is changed.

View 9 Replies View Related

Use Value In Column After Sorting

Mar 12, 2009

I would like to use the value displayed in column H under the column header after filters have been applied. There will always only be one row displayed after filtering. I'm using Win Xp with Office 2003 ....

View 9 Replies View Related

Custom Sorting Of Multiple Columns?

Jun 20, 2013

In Column A there are randomly assigned numbers using the RANDBETWEEN function.

In Column B there are three possible values X, Y, and Z.

I want to create a sort order where "X" is always at the top but then the rest of the rows are randomly sorted by column A (Y and Z values are intermixed).

Currently I tried to use a Custom List and the value is "X" to sort first, and then a seconday sort of Column A. The problem is that column B is always sorted by X then Y then Z where I am trying to get the Y and Z values to be randomly intermixed based on the sort of the random numbers in Column A.

I know I can manually do 2 seperate sorts each time, but I would like to save a sort list to the file so I recreate that sort over and over again.

View 3 Replies View Related

Matching And Sorting Multiple Columns

Mar 11, 2014

I need sorting a contact list of 3000 + so the emails match with the company name, and first and last name of the contacts

Column A is Email and Matches column C & D. Column B matches with Column E. I need A to match with B-E.

I've attached an example : Example Spreadsheet.xls

View 2 Replies View Related

Sorting With Multiple Rows Per Entry

Feb 24, 2006

I've come upon a problem with sorting that I don't know how to tackle... I have entries in a workbook that I want to sort by a transaction number, but each entry spans multiple rows. One "entry" might look like this, for example:

TransID PassengerName Ticket#
leg of travel: Departure Arrival
leg of travel: Departure Arrival

I need to be able to sort by TransID or PassengerName while keeping the "legs of travel" attached to the correct TransID/Ticket#.

View 17 Replies View Related

Sorting Data That Has Multiple Formats?

Jun 15, 2012

I have lists of products that I want to sort, but all the skus are in different formats, some letter, numbers, spaces, symbols and mixes of all.

Example:
01107919
CE-4128B9
RED-BRIC889
1124
14100119020-E
86TR
ECO CUP22OZ/1000
1418909888783301

I would like to organize them by the order of the numbers, letters and symbols, not the value of the numbers.

Example:
01107919
1124
14100119020-E
1418909888783301
86TR
CE-4128B9
ECO CUP22OZ/1000
RED-BRIC889

I have tried formatting and different sorting options but there's a dent in the wall and my forehead is getting bruised from all of the banging.

View 2 Replies View Related

Sorting Multiple Sets Of Data

Aug 22, 2012

Create a macro or some other solution to sorting my data. Just clicking on Sort Ascending isn't good enough because it'll sort everything and remove the empty rows. However, I want the empty rows to stay there. The way that I've been doing this is manually. Basically, after the empty rows were inserted, I'd click on a cell in Column A and click on Sort Ascending, then I'd scroll down and click on the next set of data and click on Sort Ascending, then the next set and the next. I'd end up having to do this hundreds of times.

I've uploaded an example of what I'm talking about, I also labeled the tabs as "I want this" and "to look like this":

Example file.xls

View 5 Replies View Related

Sorting Multiple Rows Horizontally?

Apr 11, 2013

I have over 300 rows with a username in the column A followed by 3 fields in the following columns B,C,D. I want to just sort all 300 rows alphabetically by column B,C,D.

Eg. Cormac, Santa, Atlas, Egg
After search Cormac, Altas, Egg, Santa.

how to do this easily in Excel without VB as I am not good as it.

View 6 Replies View Related

Sorting Multiple Columns Alphabetically

May 2, 2013

How do I sort multiple columns alphabetically with the last name first, then the first name as the 2nd sorting option?

Here is an example of what I have:

year; first; last
2011 chrisBell
2010 chrisBell
2009 chrisBell
2008 chrisBell

[Code] .......

As you can see, the first names aren't sorted 100% alphabetically. I think issue stems from the years 2001 n-2006 n. I have to use the 2001 n since its a different data than the normal 2001.

The default sorting was by year:
2012
2011
2010
2009

[Code] .......

So I want it to sort by last first, then first name. Then it should sort by the default sort I already had in the left column (years).

View 4 Replies View Related

Sorting Multiple Lines Of Data

Nov 20, 2007

I have a large spreadsheet I need to sort into alphabetical manager order.

As there are between 2 and 20 rows per manager I would like to know if I am able to sort this into alphabetical order!

View 9 Replies View Related

Sorting Info From A WS To Multiple Worksheets

Sep 30, 2009

Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing I want to do is organize it. I want to sort the Master sheet into other worksheets, and I would like to do this Industry.

Is there a way to make excel register when a contact is in a certain industry, and then subsequently move that contact into a sheet? I tried playing around with If/Then functions, but I think this is a job for a macro/VB expert.

View 9 Replies View Related

Display Multiple Rows & Sorting

May 2, 2006

Please ref attached spreadhseet.

1) Is it possible to hide all cols save D & E and also all blank rows in Col D

2) I would like to have an initial If statement saying stating that if the answer to the question in D2 is Y then don't display anything else other than the info in B2 & B3.

) the sorting seems to have gone funny - not sure what I've done here, I'd like it sorted by phase (col A)

4) where there is a blank in the cell under a question (for example D3) - this means that the same question applies and that multiple docs should be returned (e.g for Q1 D2 docs 1 & 2 display, for qu D37 docs 36 - 39 display)

View 9 Replies View Related

Sorting Info In A Column

Apr 17, 2009

I need to sort information in a column containing both numbers and words. In the "asending" & "desending" it only gives two options to choose from. (none) & PartNum.

View 14 Replies View Related

Sorting Numbers With #div/0! In Column

Oct 20, 2009

I have some numbers in a column which due to other cells not yet being filled in are returning a supressed #div/0! error. This is fine, but when i go to sort the column it puts them in the wrong order. I would like to record a macro, and assign it to the column header in order to sort the column.

View 5 Replies View Related

Sorting A Column By Time?

Jul 23, 2013

I am trying to sort a column so it'd be like a schedule the earliest time on top and latest on the bottom. I understand it is a form of custom listing but I am not quite sure what is the way to enter that list entry...attached is my excel spreadsheet I am currently working on.

View 7 Replies View Related

Sorting A Single Column

Nov 30, 2008

This is a simple question but I have been playing around with the syntax(unsuccesssfully) for a while. I want to do is sort a column (not the whole sheet). the column selection being determined by the activecell. I know I can use

View 5 Replies View Related

Sorting Dates In A Column

Jul 17, 2009

I have a list of dates in a column that I need to sort. Dates in columns are as follows for example:

02/15/2010
05/02/2009
06/11/2033
04/05/2044

When I get do a sort I get the following result (it appears to be sorting by month, day, year)

02/15/2010
04/05/2044
05/02/2009
06/11/2033

I want to sort by year, month, day. Desired result as follows:

05/02/2009
02/15/2010
06/11/2033
04/05/2044

View 2 Replies View Related

Edit VBE For Sorting Given Column

Aug 8, 2013

I currently have a macro that will sort a given column from A1:A5000. The data set can change from A5000 to A6000 or more. How do I edit VBE to accomodate this?

View 6 Replies View Related

Sorting On Column Within Range?

Nov 5, 2013

I am trying to sort a range of data by 1 column (column D), and get the following error:

"The sort reference is not valid. Make sure that its within the data you want to sort, and the first Sort By box isnt the same or blank."

Having googled and also checking some previous posts, I thought the issue may be around qualifying my key to ensure that I used the active sheet, but having done this, I still get the error.

CodeRange("A2:V2", Selection.End(xlDown)).Select
ActiveWorkbook.Worksheets("Overview").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Overview").Sort.SortFields.Add

[Code]....

View 3 Replies View Related

Sorting A Column Using A Macro

Feb 9, 2009

I have Column A where user inputs data. Whenever a user enters a new value in Column A, I need to copy that data into Column B and then sort the whole column. Any suggestions on how to do this using a macro?

View 9 Replies View Related

Sorting With Refrence To Other Column

Mar 2, 2010

[data]...

now this is the data i have(theres more but this is just an example), i want to sort it with refrence to 'inv' column such that i hav ....

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved