Sort The Data In Numerical Order?

Dec 17, 2013

I have imported data and numbers from a website and would like to sort the data in numerical order. Excel wants to sort the data 1,10,2,20... in that order. I know from past experience with an older version there was a way to convert the numbers so they can be sorted in the way that I want.

View 2 Replies


Sort By Both Alphabetical And Numerical Order

Feb 20, 2009

I have a spreadsheet for work that consists of various columns of data. One important sorting column would be Job #. Inside this coulumn are data like 134-Q and 2355-P and 755-P for example. The sort now is like posted. I would like to be able to sort by both alphabetical and numerical order. ie, 755-P, 2355-P, then 134-Q.

View 5 Replies View Related

Sort Worksheets By Numerical Order

Oct 11, 2007

I am trying to sort worksheets in excel by numerical order. I have renamed each worksheet with a different zipcode that corresponds to data on that sheet.

I believe there might be two ways to do this,
1) by sorting numerically the worksheet names.
2) by perhaps referencing a cell on each worksheet (i.e. the zipcode) and sorting it that way.

View 7 Replies View Related

Sort Numerical-Text In Order

May 14, 2008

I am trying to sort different SKU #'s for my amazon store on excel. I go to Data... Sort... Ascending and it comes out like this...

and so on...

i want it to be like this

View 3 Replies View Related

Use VBA To Sort Data In Particular Order

May 9, 2014

I have a list of data with headings number,name, surname,group. Data needs to be kept in the rows as they are now but I would like to sort the order by group. The group order needs to be:

sm, u17m, u15b, u13b, u11b, sw, u17w, u15g, u13g, u11g. I would like to do this using vba and have a blank row between each group.

View 11 Replies View Related

Sort A Column Of Data In Ascending Order

Sep 1, 2009

I am trying to sort a column of data in ascending order but I am not getting the results I expect. An example of the data held in the cells is:


When I sort it in ascending order it sorts like:

View 4 Replies View Related

Auto Sort Column Data In Order?

Apr 8, 2012

Im am looking for a way of automatically sorting the data I have in column "C" (C2:C99 to be exact).

The data represents stock codes which are a mix of text and numbers, starting with 1 letter followed by numbers.

I would prefer something I can put in the sheet tab view code section, so that when any new data is added or altered it automatically sorts the stock codes in to alphabetical then numerical order



View 3 Replies View Related

Sort Data In Chronological Order Of Periods

Feb 1, 2008

I will need to sort the data based on some number entries being presented in Periods 1 ,2 ,3 in chronological order.. i.e. move the data of period 1 to the top , then period 2 and then period 3.

View 5 Replies View Related

Automaticcally Sort Data In Ascending Order

Apr 11, 2008

Need code for automaticcally sort data in ascending order any time there was a change in score. The names column is b1:43 and the corresponding score would be in column c1:43. I can't seem to do it.

View 9 Replies View Related

Insert Row In Numerical Order

Feb 22, 2010

I need to be able to enter a number in a cell, A1 for example, activate a button, and have that value placed into a new row below in numerical order, then the entry in A1 deleted so more entries can be made

For example, if F1=6, G1=8 and H1=9, if I enter 7 in A1 and run the macro, a new row is created (G becomes H, H becomes I, etc) and 7 is placed in G1, A1 is cleared.

What I'm up to is inventory where the items are all numbered and more of the same number can show up with a larger number, like XXXX1 and XXXX2 that are the same item, or different item YYYY1 that may only show up once. Row gets deleted when inventory is removed from "back room" and goes to sales area so the list will only carry 40 or so items at any one time.

View 2 Replies View Related

Excel 2007 :: Data Sort In Ascending Order

May 23, 2012

Excel 2007.

The first part of this code is fine and completes all the borders.
The second part is to the all the workbook by Data Sort in ascending order starting with

Column C
Then Q
Then column V

But also knowing to search to the last line. I think i might be close but not close enough for this to work.

Sub Macro2()
Dim LR As Long, i As Integer
Dim mysheet As Worksheet

LR = Range("A" & Rows.Count).End(xlUp).Row
With Range("A9:AD" & LR)

[Code] .......

View 2 Replies View Related

Sorting Column In Numerical Order

Jul 19, 2013

I have a column that has something like:


How do I make it to be the order of bigger number to smaller number?

I tried Data > sort Z-A, but then some of the numbers disappear and become "--"

View 2 Replies View Related

Arranging Numbers In Numerical Order

May 26, 2012

I'm looking for a formula that will rearrange a row of numbers in numerical order and by their last digit also in a numerical order, I hope it's clear enough !!!

2 1235781114162022273139667197110113128136139153225250328428508576772 3
4 2011025011131712227723113153145225166613657672797812832842850839139 5

View 9 Replies View Related

Only Digits Selected In Numerical Order?

Jul 30, 2012

From I51 :R51 are the skips of each digit contain in the combination from C51:G51 meaning that the combination : 7 8 47 51 52 is composed with the digits 1 2 4 5 7 8 those digits have their own column with their skips in it, and I would like starting in cell T51 and dragging to the right the skip of only those digits and in a numerical order.



View 2 Replies View Related

Finding File Name By Numerical Order?

Sep 12, 2012

I have an excel sheet that will create a standard filing system.

in a folder there are folders numbered like this:

"ENQ 0123, ENQ 0124" and go up 1 digit at a time.

there are hundereds in this folder. I would just like to know if there is a quick way of finding the latest one so i can then tell my code to generate the next one.

View 9 Replies View Related

Sort Command - Custom Order Or Sort Ascending Or Descending

Oct 8, 2006

Is it possible to make excel sort ascending or descending but from mid way through alphabet and then loop through the alphabet again. for example. If Cell A1 had "A" in, it would sort as normal.

Cell A1 = A
Cell A2 = B
Cell A3 = C
Cell A4 = D
Cell A5 = E

If Cell A1 had "C" in, it would sort from "C" through the alphabet and then loop to the start of the alphabet as shown below.

Cell A1 = C
Cell A2 = D
Cell A3 = E
Cell A4 = A
Cell A5 = B

View 4 Replies View Related

Excel 2007 :: Dragging And Inputting Cells Into Numerical Order

Mar 25, 2014

Excel 2007. At the bottom of a column of data I'm trying to reference the cell $AG4. There are 340 total columns. Each additional column to the right needs to reference the next cell in column AG. So I'm trying to drag and copy horizontally from $AG4 to $AG340. When I try just the single column it just copies $AG4 into everything to the right. When I have to columns ($AG4 and $AG5) and grab both to try to copy horizontally the numbers increasing it just does $AG4, $AG5, $AG4, $AG5, etc.

View 2 Replies View Related

Arrange Numerical Values In Order From Lowest To Highest In Column

Jun 19, 2014

Trying to arrange numerical values in order from lowest to highest in a column i have a code to do that but i need it to be able to but to a range in the column so it only sorts the values in rows 3 - 60 not all of the rows in the column

Sub Testsort()
Selection.Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
End Sub

View 9 Replies View Related

Sort And Group Names Then Sum Associated Numerical Values For Each Group - Sort Total

Apr 18, 2014

I have this massive spreadsheet, with the maximum rows excel will fit on one sheet. In the interest of simplicity, this is what the raw data looks like:

Last First Amount

Jones Jim $1000
Jung Joe $700
White Jon $100
Jones Jim $200
Jones Jan $300
Jung Joe $800
White Jon $200

What I want to do is automatically get excel to group all the same names together. Then I want it to sum all the values for each name, then order by largest total value for each person, then order that by name alphabetically. In other words, the above would look like this after the sort:

Last First Amount
Jung Joe $800
Jung Joe $700
Jones Jim $1000
Jones Jim $200
Jones Jan $300
White Jon $200
White Jon $100

Or, if necessary, there could be sum total rows under each name...although I don't have spare rows, so IDK. I could delete some rows if I had to, but would rather not.

View 1 Replies View Related

Sort - How Can I Order Then In B1:B60

Aug 2, 2007

i have A1:A60 filled with numbers. however, they are ordered incorrectly. how can i order then in B1:B60 in the following way?

1st cell
7th cell
13th cell
19th cell
25th cell
31st cell
37th cell
43rd cell
49th cell
55th cell
2nd cell
8th cell
14th cell
20th cell
26th cell
32nd cell
44th cell
50th cell
56th cell


until the 60th cell

View 9 Replies View Related

Sort Ascending Order

Feb 10, 2009

I need values from column F in ascending order.

Also I need in column G only the values without formula.

View 14 Replies View Related

Sort Order And Text ..

Nov 20, 2007

I'm sure this has been asked many times before, but I can't seem to find an answer that works for my data. I have some data that is sorted by an ordered list (like a table of contents from an overly detailed book):


This list can be arbitrarily deep (although probably not more than ##.##.##.##), and because I'm using periods to separate the nested levels (can be changed), I've formatted it as text. This means when I sort the data using this column I get 1.11 before 1.2 (text sort order).

After lots of failed formula attempts I've resorted to using an additional column with hand-entered values to sort by so it will sort correctly:


but I'm hoping someone knows a more elegant way to do this, or at least to generate this column without typing so many zeroes!

View 9 Replies View Related

Weird(?) Sort Order

May 30, 2008

I have a client with a list of books, and they are trying to sort a column in a sheet that has LC classification codes. When just doing a normal A-Z sort, it looks like this:

RJ 41 .D53 F54 2005
RJ 416 .L4 C52 1999
RJ 420 .D5T97 2003
RJ 421 .H385 2006
RJ 426 .H43 P43 2005
RJ 431 .M37 2003
RJ 436 .A8 R33 2006
RJ 436 .A8 T498 2001
RJ 436 .A8 T87 2003
RJ 45 .N4 2000
RJ 45 .N418 2006
RJ 45 .R92 1998
RJ 47 .E39 2001
RJ 48 .H37 2000
RJ 48 .H37 2002
RJ 48.2 .C537 2004
RJ 48.2 .P347 2005
RJ 48.2 .P385 2005
RJ 48.2 .R93 2003
RJ 480 .P34 2005
RJ 482 .R48 L448 2004
RJ 486 .C45 2000

What is weird about it is that I would think that the numbers after the RJ would be in numeric order but it seems to be treating them as codes. So, instead of RJ 41, then RJ 45, it goes on with a series of things that start with RJ 41. Is it normal for this to happen, or is there a way to change it so that it goes 41, 45, 47, 48, then 416, 420, etc.

View 9 Replies View Related

Custom Sort Order

Feb 13, 2007

I feel I've searched thoroughly and wasn't able to find the right answer. I've attached a daily report example that needs the "Product" field to be sorted in a particular order. The order should be JEX, Q3791J, YOO5, KLX9, GHT (all similar products need to be grouped together).

Since the report is run daily the number of rows changes daily: one day can have 50 entries and the next 10. Is there a way to dictate the sort order and insert a blank row between each product grouping?

Once the Products have been separated into their groups, how would I sort each grouping by the "Term" column?

View 9 Replies View Related

How To Sort ListBox In Ascending Order

Jun 14, 2014

I have 2 listbox (List1 and List2). List2 get populated when the user select a value in List1 and based on the value selected in List1. My issues are:

1- Values in list2 are not sorted in ascending order especially when the list2 grows over 32.
2- When the user selects "None" in List1, it should clear List2 (onclick)

I worked on this code for a while with no luck trying to get it to work. Is that doable?


Option Explicit
Dim ufEventsDisabled As Boolean
Function SelectedString() As String
Const Delimiter As String = ","
Dim i As Long

[Code] .....

View 9 Replies View Related

Automatic Sort By Descending Order?

Mar 15, 2014

Don't know if macro is better, but I would like to try it with function

I have 2 sheets.

Sheet 1
Column A: Name
Column B: Points

Name Points
Mary 40
Johnny 20
Erick 60
Ralph 30

I want Sheet 2 to get data from Sheet 1 and sort by descending order automatically.

Then it should be

Sheet 2

Name Points
Erick 60
Mary 40
Ralph 30
Johnny 20

I don't want to do it manually every time I change some value; I want it to do automatically; so if I change, for example, Erick's points from 60 to 10 in Sheet 1, Erick should appear on the last place in Sheet 2, with his new value (10)

View 1 Replies View Related

How To Sort Dates In Chronological Order

May 1, 2013

My dates are sorting as per the image below.How do I get them to sort in chronological order (e.g. 01 January, 02 January etc)

Excel Forum.PNG

View 10 Replies View Related

Sort Numbers Into Ascending Order Across A Row

Nov 5, 2008

Im totally new to excel and have some data i need to sort. how to sort numbers into ascending order across a row. ie, I have 34 2 45 79 102 63 etc, and I need them to start low and order to high. i have over 1200 rows, so it would be good to do the whole sheet at the same time.

View 4 Replies View Related

Sort By Reverse Order First Letter Of Last Name

Oct 19, 2009

I have to sort data on 3 criteria

The data is:....

At this time I sort by HOURS then Seniority so the sort would look like this:........

Here is the problem, RN HILLER and JA DOE have the same hours and seniority. It is our policy that when 2 or more names and seniority match, they must be sorted by reverse order first letter of last name.

So this would be correct. H in Hiller comes before D in doe when reverse sorting.....

View 4 Replies View Related

VBA - Sort Worksheets In Same Order As List

Oct 7, 2011

I have the below code that sorts a list of Doors that I have in row C17 downwards. Door 54, Door 7, Door 109 etc. The list is feeding a drop down box, people find the door they were looking for, in the said drop down box.


Sub ListSorter()
Dim LastRow As Long
LastRow = Range("C" & Rows.Count).End(xlUp).row


I wondered if there was some code I could add to the end of this, that would the sort worksheets, which are all named after each cell in the list, in the same order.

View 3 Replies View Related

Copyrights 2005-15, All rights reserved