Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort 1 column and another changes
Sorting Problem is explained in example 2. Example 1 is the control. It is
when I do something different in example 2. Example 1: Column "A" has title - Letters. Column "B" has a title - Numbers. I fill column "A" with the "letters" from A to F. I fill Column "B" with random numbers such as€¦ 43, 1.6, 57, and 9. I want to keep my random numbers€¦ as is in column B. All is good! Repeat, I put the title €“ Letters in Column E and Numbers in Column F. I HIGHLIGHT COLUMNS E & F €“ CURSE IS IN THE NUMBERS COLUNM €“ F. When I sort the numbers in column - F, also€¦ column B €“ Numbers changes as well. You can see what I want. I want to sort column F numbers without changing Column B €“ Numbers. What is the search for my problem? Portland, Oregon Martell |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort 1 column and another changes
Hi
When you sort the col F select the cells up to the data and on the menubar you will find a sort button saying A/Z and arrow would be downwards. Click this button and a window will open giving two options. 1) expand the selection range. 2) continue with the current selection. If you choose option 1) both col E&F will be sorted as per col F and if you choose option 2) only col F will be sorted and nothing will change on the other side of the tables. Try and let us know. -- Thanks Suleman Peerzade "MUTTMIND" wrote: Sorting Problem is explained in example 2. Example 1 is the control. It is when I do something different in example 2. Example 1: Column "A" has title - Letters. Column "B" has a title - Numbers. I fill column "A" with the "letters" from A to F. I fill Column "B" with random numbers such as€¦ 43, 1.6, 57, and 9. I want to keep my random numbers€¦ as is in column B. All is good! Repeat, I put the title €“ Letters in Column E and Numbers in Column F. I HIGHLIGHT COLUMNS E & F €“ CURSE IS IN THE NUMBERS COLUNM €“ F. When I sort the numbers in column - F, also€¦ column B €“ Numbers changes as well. You can see what I want. I want to sort column F numbers without changing Column B €“ Numbers. What is the search for my problem? Portland, Oregon Martell |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting a set of columns
Excel 2007: When I sort the col F (numbers)... "up to the data" (not a clear
picture). I put the cursor in the top number cell (F) and use the shift key to highlight both letter & number columns? The options you mentioned in sort menu, are you referencing Excel 2007? Expand sorting range, I do not see. Its A to Z, Z to A or custom sort. The objective is to sort letters & numbers by a value of numbers. A-2, B-7 & C-3 becomes B-7, C-3 & A-2. I can sort numbers - that does not tell me anything of use. Please, let me hear from you. There is a data tab. My answer is there? Portland, Oregon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions |