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.

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.

- Sort Largest to smallest automatically
- How to write a macro to sort many columns from largest to smallest
- Numerical order largest to smallest
- Functions largest to smallest
- Order data from largest to smallest using formula
- AutoFilter causes cells to go blank when sorted
- Sort by largest number in column by Formula Function
- Sort Largest to Smallest For Column Pairs
- Is it possible to customize the autofilter dropdown list?
- Ranking and Sorting
- Maintaining table column sorts with xml imports
- Sorting in Pivot Table
- Sorting problem with COUNTIF across sheets
- How list highest to smallest values?
- Sorting by array
- PowerPivot: Sorting based on a Values column
- Bar graph question
- Bar graph colors question
- Continuously running a recorded macro-Please Help
- Hyperlinks not working upon filter.
- Export selected rows to new worksheet then sort in descending order
- Ranking cells largest to smallest
- Unable to sort "words" that are numbers and letters
- Unable to Sort Numbers in PT?

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

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!!!

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

You guys have been a great help so far,

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?

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

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!

Please Help Me !?

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

Attach File is Uploaded

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

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

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.

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!!

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.

=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...

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!

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).

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

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!!

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

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,

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

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

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

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.