Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help on sorting data
Hi,
I have a soccer grid result. So I would like the column corresponding to the points of the teams sorted descending. But I want the other column to follow. And I want the first column (rank) to remain still and not affected by the sorting operation. How can I do that ? thx |
#2
|
|||
|
|||
Just select the columns you want to sort, and then sort.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sam" wrote in message ups.com... Hi, I have a soccer grid result. So I would like the column corresponding to the points of the teams sorted descending. But I want the other column to follow. And I want the first column (rank) to remain still and not affected by the sorting operation. How can I do that ? thx |
#3
|
|||
|
|||
thx
actually i've managed to do that but how do i do it programmatically, that is in a macro ? How do I refresh the sheet ? tx |
#4
|
|||
|
|||
If you record a macro when you do it manually (once), you'll see the basic code.
If you need help modifying it, post back with the code you recorded. Sam wrote: thx actually i've managed to do that but how do i do it programmatically, that is in a macro ? How do I refresh the sheet ? tx -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting with data on alternating [every other] row | Excel Worksheet Functions | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Need Further Help Sorting Data | Excel Worksheet Functions | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |