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


ADVERTISEMENT

Columns Sorting Alphabetically Seperately And Each Has A Header Row

Oct 14, 2008

I have the following code that sorts each column sperately and it works, but believe this is a long way round and not the best way. I need the columns sorting alphabetically seperately and each has a header row.

View 2 Replies View Related

Using Array Formula To Sort Alphabetically Over Multiple Columns

Feb 14, 2014

In the attached example file, I have two tabs: options and sets. The options tab is to be populated from a form. The sets tab is to draw data from the options tab to create teaching sets. I have managed to create an array formula that does this for me, but what I would like it to do is sort my resulting list alphabetically. For reasons that I won't go into, I need the data on the sets tab to remain in three columns: First Name, Surname and Form.

This is the array formula I am using at the moment: AliGW - Example.xlsx

View 14 Replies View Related

Sorting SOME Worksheets Alphabetically

Aug 27, 2009

I have been looking at Macros that sort worksheets alphabetically, but there are sheets within my workbook that I want to leave static. I have two sheets, names 'Start' and 'Spacer', what I would ideally like to have is a marco that will alphabetically arrange the sheets between these sheets, leaving the others where they are and obviously leaving 'Start' and 'Spacer' at the front and end of the range respectivly!

View 5 Replies View Related

Sorting Excel Alphabetically Maintaining Spaces

Feb 24, 2014

I have data arranged in columns A-F. I am wanting to set it up so those groups are all based on the name in column A:

Name Location Quantity Notes Etc.

Joe Likes bread
Hates butter
Jane

Julio

Column A only takes up one space, while the other columns take up 3-4 spaces on average. I am looking to sort column A alphabetically while maintaing the spaces between so that the info doesn't become jumbled.

View 8 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 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

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 A List Of Numbers By Multiple Columns

Oct 13, 2008

I want to sort the list like this:

1) If there is a zero (null) value in all 3 months, these records should be at the bottom sorted by record name (I did not show this field in my file).
2) If there is a non-zero (non-null) value in any of the 3 months, the records will be sorted with each other by total change.

Is there a way to do this without me doing sorts multiple times and manually moving rows of data around (which is what I have done to arrive at the list I have attached)? I am not experienced with VBA or Macros, and would prefer a detailed explanation if a solution is using either method.

View 2 Replies View Related

VBA / Macros - Sorting Across Multiple Repetitive Columns?

Jan 27, 2014

I have attached an example spreadsheet with two tabs. The first tab (Matrix) shows raw data scores - there are 28 measures in Column A and Participants in Row 1. There are always 28 measures but participants can vary. What I need to happen is to sort each measure in a Lineup tab i.e. rank all the participants listed in the Matrix tab from lowest score to highest score for each of the 28 measures. Obviously this can be done manually but a VBA/macro solution will be so much faster and easier. Unfortunately I have to keep the data in this format so the macro will need to transpose the data to get into the formt in the Lineup tab.

View 9 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

Excel 2010 :: Sorting On Multiple Columns - Method Range Of Object Global Failed

Feb 25, 2014

I need a macro to sort on five columns (Column A, L, P, X, and Y) out of about 33 columns. Sort is all lowest to highest.

The code I have so far is:

Sub Macro1()
Range("A2:AG").Select
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range("L2") _
, Order2:=xlAscending, Key3:=Range("P2") _
, Order3:=xlAscending, Key4:=Range("X2") _
, Order4:=xlAscending, Key5:=Range("Y2") _
, Order5:=xlAscending
End Sub

However, I get an error "runtime error 1004 - method range of object global failed".

View 1 Replies View Related

Sorting 4 Columns Together

Nov 6, 2007

Is there a code or some way for me to sort 4 columns together? I want to sort a list of employees and for each employee theres a column with their Lost Business, customer satisfaction, and two more columns. I want to sort all the columns at the same time so that the best employees overall will go to the top of the list and the worst ones will be at the bottom. Whenever I use the sorting feature it does each column independant of the others so everytime I sort a new column it just moves around the last one I sorted.

View 14 Replies View Related

Sorting When Using Columns Beyond AA

Oct 6, 2009

Im not entirely sure about this but it seems like if I have data in columns A - Z and sort in one of them, the data in Columns AA - AZ does not move accordingly rather it stays fixed.

View 4 Replies View Related

Sorting Columns

Apr 13, 2007

I have a spreadsheet that is populated my Concatinating data from other worksheets. Some of the results are numbers, some is data while others are blank spaces and othersare set by the concactenating default of "" when the criteria is not met. I need to sort these colums. However it seems that the default "" from the formula is not a BLANK or a ZERO or an empty cell.

Those cells will place themselves at the top of the sort. I need to eliniate them. I have copied and pasted as values but that has no effect. Ironically I can identify the cells with an if statement so what I need help with is generating a macro that will cycle thru the range of results and delete the approriate cells.

I have tried the following:

lr = Range("A1").End(xlDown).Row ' Last Row
lc = Range("A1").End(xlToRight).Column ' Last Column
For Each cell In Range(Cells(1, 1), Cells(lc, lr))
cell.Select
AC = ActiveCell
If AC = "" Then Selection.Delete Shift:=xlUp
Next

But this does not work as it cycles top to bottom and leaves behind 1/2 the problem cells.

View 7 Replies View Related

Sorting Data Into Several Columns?

Aug 14, 2014

I have an issue with some data that I need to sort into several columns. Basically, I have a column that has data listed in each cell like this; A 567 T 1 D3. What I want to be able to do is sort that data into several columns. I am not sure how to do this at all. I have attached my data to be looked at. I have already started the process but manually, and I don't feel like having to do this manually as this is very time consuming considering I am trying to sort the data into ~1927 rows and 5 columns.

View 2 Replies View Related

Sorting Data Into Columns

Aug 5, 2009

I need help with either a formula or macro for sorting data into specific columns. I need the entries under the headings Ar,Bj... to be sorted into the correct columns. To add to the problem, the data may not be exactly the same as the heading.

Attached is an simple example of a spreadsheet where the top is the original and the bottom is what I need the final outcome to be. The data is pasted from a different spreadsheet and will be changing each time.

View 12 Replies View Related

Sorting Columns Of Different Lengths

Oct 15, 2009

I have three columns, one column is time every two seconds with data associated that time, and one is time every minute with an associated tidal height.

I want to sort my data so that for every 2 seconds I have an associated tidal height for that minute.

eg:
what I have:
Time Time Tidal Height
(2 sec intervals) (min) (meters)
1:15:00 1:15 1.342
1:15:02 1:16 1.221
1:15:04 1:17 1.115
...
1:15:58 1:43 0.024
1:15:60 1:44 0.012
1:16:00 1:45 0.008 ....................

View 2 Replies View Related

Matching And Sorting With Two Columns?

Jul 23, 2013

I am trying to 'stagger sort' multiple columns, but am having some difficulties.Ex.

Say A and B are lists of part no and C is data corresponding to column B. I have:

A B C
1 2 .
2 3 ,
4 4 ;
5 7 '
8 9 "

I want:
A B C
1 _ _
2 2 .
_ 3 ,
4 4 ;
5 _ _
_ 7 '
8 _ _
_ 9 "

(the _ are just supposed to be empty place holders, without them I have formatting issues)

Is there a 'quick' way to sort them this way?I am attaching the actual file that I am working with.

View 9 Replies View Related

Sorting Columns Instead Of Rows

Jan 14, 2009

I have some data that is 300 rows x 43 columns.

I'd like to sort the 43 colums by using some of the rows. Is this possible using normal excel?

Alternatively is there a simple way to sort the colums in VBA?

View 9 Replies View Related

Sorting Spreadsheet By Priority Columns

Jun 14, 2014

I'm managing a World Cup Prediction League and have been trying to create a spreadsheet that will eventually feed in to a league, positioning each player in descending order. However, I would like to use three columns to determine how to position the players.

EG.

Priority 1 - Column D - Total Points (Rank from Highest to Lowest)
(if there are players with equal Total Points in column D, then)
Priority 2 - Column F - Correct Scores (Rank from Highest to Lowest
(if there are still players with equal value after Total Points and Correct Scores, then)
Priority 3 - Column F - Incorrect Scores (Lowest to Highest)

I've tried for hours to work this out but can't. It would save me hours of work each day

I have attached the document : WC Prediction League EXAMPLE.xlsx‎

View 14 Replies View Related

Sorting Columns With Common Values

Nov 25, 2009

I have two sets of 2 columns. One column in one set is identical to a column in the other set, but they are arranged in different orders. I would like arrange those two columns side by (matching their numbers) so that I can find the average of the two non-identical columns.

View 2 Replies View Related

Sorting By Columns But Keeping Rows Together?

May 23, 2013

I'm trying to sort by City first, then by Report #, but keeping the highlighted rows together. If I use the custom sort it will through my D2's at the bottom and not keep them with their city, report, and D1. How do I get them to stay together? I have attached my document example.

View 4 Replies View Related

Sorting Rows Based On Columns

Jan 20, 2009

I have a worksheet with columns of Unique Words and corresponding Frequency of Occurrence for several years. I would like to sort the data so the rows match up on same Unique Words across years.

I am using Excel 2007.

View 9 Replies View Related

Sorting Data With Locked Columns

Feb 20, 2009

I have a spreadsheet on lets say 10 columns, now col 1 and 9 are locked so they cant be selected. Col 2-8 can be sorted by selecting them, but information in col 10 does not sort.

Question is there a way of connecting the cells in col 10 to the cell in lets say col 2, so thay when you sort the rows and cols between 2 and 8, the cells on col 10 are sorted as well As i have noticed you cant sort two differenr selections...???

View 2 Replies View Related

Excel 2007 :: Sorting Across Columns

Oct 3, 2011

Excel 2007 - Sorting across columns

Need to sort part of an Excel worksheet across multiple columns.

For example data is:

ABCDEF1
Machine
4394264394294394434399834399842
Model
TD860TD400TD860TD620TD6203
Pgm
OPTABCOPTEP2EP24
Start
5/31/119/1/115/1/096/15/092/1/085
End
2/28/158/31/125/31/114/30/108/31/09

I need to sort it first by Pgm, within Pgm by Model, and within Model by Machine. I do not need to sort on Start or End

The results should look like:
ABCDEF1
Machine
4394294399834399844394264394432
Model
TD400TD620TD700TD860TD8603
Pgm
ABCEP2EP2OPTOPT4
Start
9/1/116/15/092/1/085/31/115/1/095
End
8/31/124/30/108/31/092/28/155/31/11

After selecting the data to be sorted (columns B,C,D,E,F), I tried using "Sort Left to Right" under DATA-SORT-OPTIONS but it doesn't seem to work.

View 3 Replies View Related

Sorting Columns To Align Data

Jan 16, 2012

I have to filter data in one column and have it align with data in another column. I need to do this because I have hundreds of product descriptions that I need to match up with the appropriate images. All of the image names will be like the first row (1244-?????.jpg) The problem I am running into the text data I am downloading is not matching up with the images. I usually have more images than text and sometimes I will have text that has no corresponding image.

1244-540299.jpg Golden Poinsettia Triple Candleabrum 1244-540299.jpg
http://img.auctiva.com/imgdata/1/3/2/1/0/4/0/webimg/539293145_o.jpg
1244-540300.jpg Poinsettia and Berry Triple Candleabrum 1244-540300.jpg

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

View 5 Replies View Related

Sort Columns Without Sorting First Column?

Jun 28, 2013

I want to sort columns A,C:P and use column C as the column that I sort and the other rows will move with column C. I want column B to stay and not move with the sort. How can I do this.

View 2 Replies View Related

Sorting VBA Array On Worksheet On Two Columns?

Aug 30, 2013

I'm trying to sort an array which is of variable height/rows when put on a worksheet. I need to sort by column C ascending (smallest to largest) and then by column D ascending (oldest to newest). I tried recording a macro but the code is just junk.

Code:

Dim BookSPSortingWorksheet As Worksheet
Dim TR As Range
Set BookSPSortingWorksheet = ThisWorkbook.Worksheets.Add
Set TR = BookSPSortingWorksheet.Range("A1").Resize(UBound(array_book_SPNames), UBound(array_book_SPNames, 2))
TR = array_book_SPNames

Is there a way I can use the sort function like the below by indexing my TR range for columns 3 and 4?

Code:

TR.Sort key1:=TR, order1:=xlAscending, MatchCase:=False

View 3 Replies View Related







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