| 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 |
| 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 | |||
Threaded Mode
