Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Sorting Largest To Smallest

I already have a file showing the way to do the above however I want a different approach...

I have used the Array formula which helps me in Sorting Data but though it works it unfirtunately makes the computer go slow....

Can anyone please suggest a different approach...

Please go through the file....

Thanking you in anticipation.


Post your answer or comment

comments powered by Disqus
Hi there
I have a spreadsheet where I would like to sort largest to smallest automatically as the numbers are updated. Column A is the name and Column B the number.
Could anyone help?
Example attached
Kind regards
John

SOLVED Hi all,
Background: I am trying to sort columns AN-BQ by largest to smallest. Apparently, when you sort a column largest to smallest and then you do it to another column, the first column stays in tact. For example, lets say I sorted AN largest to smallest, and then I did the same to AO, and then to AP. It would not mess up column AN. It would look like this
AN AO AP
X X 10
X X 9
X X 8
X 10
X 9
X 8
10
9
8
Since there are a lot of columns, I don't want to click sort from largest to smallest a lot of times. I have to do this twice a month for work and I am trying to get a macro to do it. Does anyone have any suggestions? I think it might involve a loop. I am quite noobish at excel VBA.
I have uploaded an examle file. I cannot upload the real file due to sensitivity of information. In the sheet called original is the raw data. In the next sheet, only columns B and C are in the correct format. If I format the rest of the columns, it gets messed up. Also, my boss was the one that told me the columns would not be messed up if I sorted the other columns but so far I have not seen that to be true. If there a way to do that or is my boss batty?
Thank you all so, so much.

Thank you so much for helping, It is solved!!!

How does one go about having an entire column align all numbers in said column from largest to smallest, no matter what order they are placed?

Will I need to add another sheet for placing the references from?

You guys have been a great help so far,

I am looking for a function that will arrange a group of cells from largest
to smallest. This formula has to be within my worksheet. I need to show 1st
place, 2nd place, 3rd place, etc. After the program calculates the scores it
then needs to show who won these places and the name of winners.

Can someone help me with this?

Hi all,
I'm trying to put data in order of largest to smallest using the large formula but it is not working when there are 2 same numbers.
Please see attached example
Thanks in advance
Kind Regards
Boydio

Hi all, strange problem going on:

I have 3 columns of data which are pasted into their cells from another sheet. I recorded a macro to do this since I didn't want to do ti manually every time. The macro is real simple, just copies the data from one sheet and pastes its to another.

Once in its new home, the data has been responding weirdly to autofilters. They work fine when I sort them 'smallest to largest', but when I try to sort 'largest to smallest' in any of the three columns, all the data disappears! I have no idea why this would happen or, unfortunately, how to fix it. Any help would be greatly appreciated. Thanks!

hi

Please Help Me !?
i want to use coulmn "Number" sort largest to smallest in column "Sort by Largest" ; HOW !!!!!!!!!!!????????

Attach File is Uploaded

Hello

I have a worksheet with a very long range of columns. I am trying to sort column pairs. Here are the details:

COL A COL B COL C COL D ... COL GY COL GZ ROW1 1 23 1 34 ... 1 7 ROW2 2 19 2 38 ... 2 2 ROW3 3 45 3 67 ... 3 68 ... ... ... ... ... ... ... ... ROW40 39 25 39 43 ... 39 9
I am trying to sort as follows:

Sort COL B highest to lowest for column pairs COL A & COL B then Sort COL D highest to lowest for column pairs COL C & COL D... and so on and so on....

NOTE - The worksheet has alot of columns thus I do not want to have to manually select each column pair to sort. Please advise and Thank You!

BlueStar Cloud

I have one column, which contains number from 1 to 5. And if I show the autofilter dropdown list, it will look like:

sort smallest to largest
sort largest to smallest
sort by color
Clear filter form
Filter by color
Number filter
Search
(select All)
1
2
3
4
5

Is it possible to add the description to all the numbers in the dropdown list? For example,

sort smallest to largest
sort largest to smallest
sort by color
Clear filter form
Filter by color
Number filter
Search
(select All)
1 (Oregon)
2 (Washington)
3 (Florida)
4 (New York)
5 (California)

Thanks

I have an excel sheet that has managers and then each manager gets points for different stats. The last column has a total of these points. Then, I have one of the first columns rank these point. But, each time I try to sort largest to smallest in the column that has the rank formula, or the column with the total points, the ranks always change, and they never sort largest to smallest. Any ideas?

I have an XML import table with 11 columns and a variable amount of rows. I need to keep the table sorted so that column 6 "Sort Largest to Smallest" arranges the table, (column 6 only has two values: 0 & 1) then I need it to be sorted by column 7 "Sort Largest to Smallest" (Column 7 has many possible values).

This isn't a problem to set up, but any time the XML connection is refreshed, the column format is lost. I need to find a way to "Lock in" the sort rules, so that they sort in the correct order (column 6 then column 7) and a refresh doesn't wipe either rule.

Any help with this would be amazing.

I am working in Excel 2010 and I created a pivot table that had Physician Name and Procedure Description as the two Row Labels and then summed up Paid Amount in the Value area. Doing this I was able to sort the Paid Amounts within each unique Physician Name from largest to smallest by simply right clicking in the Value column of my pivot and choosing sort then choosing Sort Largest to Smallest. No problems so far.

THEN, I brought in one more Row Label, Procedure Code, and now I can't sort the Paid Amounts like I was just able to a second ago.

A couple things I noticed:

1) Procedure code is a number and it is automatically sorting this field
2) Physician Name and Procedure Code are both in bold font and the Procedure Description is not bold.

Not sure if either of these two things I noticed is preventing me from sorting the dollar amounts in my Value area. Does anyonw know why this is happening? Why can't I sort the Paid Amounts any more?

Thanks!!

I have a countif page whose data changes weekly. Each week I have to go in and manually resort the list largest to smallest. That's my first question: is there a way to have the list automatically sort?

But the more annoying problem is that when I sort largest to smallest, the cells maintain their original reference point. So while, in a list of Apples, Oranges, and Pears, upon sorting, Oranges might wind up on top, the count of oranges is incorrect, because the cell references get switched up. So let's say that Oranges has the highest count and is currently in A3, and the Countif forumla in B3 says =COUNTIF('Data Source'!A:A,Calculations!A3). When I sort largest to smallest, Oranges winds up in A1, but the Countif cell reference stays at A3. A crucial point here: this will not occur if the countif is counting from the same sheet. But if it is counting from another sheet, the problem occurs.

I really don't know if I'm explaining this well, so I've attached a sample sheet.

In the sample attached, on the "Calculations" tab, sort fruits by count, largest to smallest. You may have to manually calculate after sorting, not sure if that setting transfers.

I have come up with a workaround. When I sort, in the case of the example, the Fruit column will be accurate, it is just the Count that is wrong. So I redo the formulas again and all is well. But it is an extra, annoying step, and one I have to remember to do.

Thanks for your help.

Hi there I have this formula in cell c2:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

It brings over the name of who has the highest dollar value... is there something i can add so when i drag down it list from largest to smallest? & ran into an issue with those that have same balance... don't know how we would go around that...

I have attached my spreadsheet that I am trying to do.

Basically I want to have the array (cell U2 is the start) sort Largest to Smallest from the Closing Column (O). Which when I do this it has duplicates and which then it displays the first one of the duplicates for both. How do I get it to not do duplicates so the information is R-U are all records from the information to the left of it.

Let me know if it is unclear at what I am trying to do. Thanks in advance!

I'm using Excel 2010 and PowerPivot. I've got a Pivot Table where I'd like to sort the data based on what's in the Values column (the third column). I would think that simply clicking Sort>Largest to Smallest would work, but it does nothing. I can sort by the ID column, and by the Type column (both are Row Label columns in the Pivot Table), but not by the # of times Scheduled column (which is a Values column in the Pivot Table). Is there some trick, or am I missing something obvious?

Thank you!

ID Type # of times scheduled
17341 Block 6
17342 Block 7
17344 Block 7
17352 Block 4
17353 Block 6
17354 Block 7
17355 Block 6

EDIT: I hesitate to include the actual workbook because I work in the adult entertainment industry, and the full spreadsheet contains some material that would not be "Safe For Work" (not images or anything, but racy movie titles).

Hello everyone,

I have data with 5 variables for 10 countries, and I have made a
horizontal bar graph for each variable (so 5 graphs). This data is
linked to another page, and it is divided by variable within the sheet.
For example, the format is:

Country Variable 1
US ###
China ###
India ###
UK ###

Country Variable 2
US ###
China ###
India ###
UK ###

There is a macro that sorts each of this mini-tables, and then each
graph draws from its respective variable table. The same 10 countries
are in each table, but they are not in the same order, because they are
sorted from largest to smallest so that each horizontal bar graph is
sorted largest to smallest.

My question is, how can I make it so that each country has the same
color bar in each of the 5 graphs? For example, the US has a red bar in
each graph, regardless of its position. Is there a way to do this? I'm
no VBA expert, but is there some sort of conditional macro I can do
(any code someone has would be extremely helpful)? Is there an easier
way? Thanks!!

--
anantathaker
------------------------------------------------------------------------
anantathaker's Profile: http://www.excelforum.com/member.php...o&userid=18133
View this thread: http://www.excelforum.com/showthread...hreadid=380066

Hello everyone,

I have data with 5 variables for 10 countries, and I have made a horizontal bar graph for each variable (so 5 graphs). This data is linked to another page, and it is divided by variable within the sheet. For example, the format is:

Country Variable 1
US ###
China ###
India ###
UK ###

Country Variable 2
US ###
China ###
India ###
UK ###

There is a macro that sorts each of this mini-tables, and then each graph draws from its respective variable table. The same 10 countries are in each table, but they are not in the same order, because they are sorted from largest to smallest so that each horizontal bar graph is sorted largest to smallest.

My question is, how can I make it so that each country has the same color bar in each of the 5 graphs? For example, the US has a red bar in each graph, regardless of its position. Is there a way to do this? I'm no VBA expert, but is there some sort of conditional macro I can do (any code someone has would be extremely helpful)? Is there an easier way? Thanks!!

Hi all....I intend to run the macro continuously either by creating a loop of macro or any other way of automatically sorting the columns continuously.....please help .....thanks in advance

About macro-

i have an excel macro which simply sorts few columns (numbers in descending and ascending manner) and assigned a button to run the macro.

Few things...a) the excel is DDE linked so the the numbers are updated every second....
b) this macro was recorded so i don't take any credits for the code. My understanding is of very basic level...

I have given macro name"sortinoplusab" ....it sorts four columns- B (sort largest to smallest), Column AC- (sort smallest to largest , Column BI & CN both (sort largest to smallest)...the macro that was recorded is...

Sub sortinoplusab()
'
' sortinoplusab Macro
'

'
Range("B3").Select
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Add Key:=Range("B3"), _
SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sortino").Sort
.SetRange Range("A3:X228")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("AC3").Select
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Add Key:=Range("AC3"), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sortino").Sort
.SetRange Range("AB3:AY228")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("BI3").Select
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Add Key:=Range("BI3"), _
SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sortino").Sort
.SetRange Range("BB3:BV203")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("CN3").Select
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sortino").Sort.SortFields.Add Key:=Range("CN3"), _
SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sortino").Sort
.SetRange Range("BX3:CN203")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("CV18").Select
End Sub

Hello,
I have a spreadsheet and one of the columns is all hyperlinks with display text. They all work fine, but when i filter on the column headers it appears that the hyperlink stays with the original cell rather than with the filtered cell.
For instance,
lets say i have 5 columns and 10 rows
in A1 the value is 1 and in G1 the value is text "blah" with a defined hyperlink to www.blah.com.
lets say that in A10 the value is ten and in G10 the value is text "fubar" with a defined hyperlink to www.fubar.com

When i filter on A sorting largest to smallest, row A1 now has value of ten and G1 has text of "fubar" but the hyperlink points to blah.com instead of fubar.com

Any ideas how to correct this?
Thanks,

Hi all,

I am new to using macros and need some help. Currently using Excel 2007.

I have an Excel file that has many rows of data in columns A to G. Row 1 is the header row.

I need to be able to select x number of rows and put them in a separate worksheet in the same workbook with the header row.

Is it also possible to sort the new worksheet by Column C from Largest to Smallest?

I found the following script in another post:
http://excel.bigresource.com/Track/excel-gi1t3xnG/

However, it doesn't seem to save to another worksheet in the file.

Thanks,
Stan

I've got a large amount of data that I've sorted with a pivot table. I need
to order the data within each column of the pivot table (outside of the pivot
table).

Example:
Frequency
A 6
B 7
C 6
D 5
E 4

Obviously, the largest number in the frequency column is 7 and obviously,
the next largest number is 6. What I'm trying to do is to get Excel to list
the results by row heading (i.e., B is the largest, A is the next largest, C
is the next largest, etc.) even when there is a duplicate number. I've been
using the =large() function to no avail (it gives me a value of 6 for both
the second and third largest values). How do I get Excel to differentiate
between the two distinct values of "6"?

Thanks in advance,

Jim314

For example:

Lets say I have (all numbers and the % has been typed in manually and the
format is general)

12%
54%
34%
100%

If i hightlight this numbers (each in their own cell) and say I want to sort
them from largest to smallest, it gives the following output:

54%
34%
12%
100%

why doesnt the 100% show up first? it seems as if it is only reading the
first 2 digits when I input a combination of numbers and letters. The sorting
will work fine if they are just numbers.

any one has any idea of how I may fix this? keep in mind that I do need the
% after the number and sometimes even more words in the same cell.

thanks

Hi all,

I have a PT with a list of values in it, and normally I sort these values from largest to smallest, however with this particular report I unfortunately cannot sort, I keep clicking the button and nothing happens?

Whats going on?

Thanks!

Scott


No luck finding an answer? You could always try Google.