Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO YOU SPECIFY A RANGE TO SORT?
I have a worksheet with 5 columns the first of which is simply an "item #".
Essentially it's just a row # and keeps track of how many entries there are. The problem is when I sort the worksheet, it includes this first column and makes this info useless. So I want to sort the other four columns without affecting the data in this first column. Basically I want to specify the range. Can I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO YOU SPECIFY A RANGE TO SORT?
Select the range first, then use DataSort... Then it will sort only the
selected cells. -- Regards, Fred "george" wrote in message ... I have a worksheet with 5 columns the first of which is simply an "item #". Essentially it's just a row # and keeps track of how many entries there are. The problem is when I sort the worksheet, it includes this first column and makes this info useless. So I want to sort the other four columns without affecting the data in this first column. Basically I want to specify the range. Can I do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO YOU SPECIFY A RANGE TO SORT?
Hi
Another possible solutions: 1. Leave the second column empty (no entries, no heading, you can hide the column) Now, when you select any single cell in datarange right to empty column, the datarange is sorted, but leftmost column remains unsorted. 2. Into leftmost column enter a formula instead of value. P.e. into cell A2 enter the formula =IF(B2="","",ROW()) , and copy it down. Now you can sort the table at your heart content - the cell A2 always displays a 2, etc. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "george" wrote in message ... I have a worksheet with 5 columns the first of which is simply an "item #". Essentially it's just a row # and keeps track of how many entries there are. The problem is when I sort the worksheet, it includes this first column and makes this info useless. So I want to sort the other four columns without affecting the data in this first column. Basically I want to specify the range. Can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the range of a table sort | New Users to Excel | |||
Sort command does not sort some columns? | New Users to Excel | |||
How do I sort a range of cells via a worksheet function | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
VBA, Excel - Find Range, Sort | Excel Worksheet Functions |