View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MUTTMIND MUTTMIND is offline
external usenet poster
 
Posts: 12
Default 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