Ok just started using Excel 2013.
Trying to sort 3 columns:
Column 1:
A1/B1
A2/B2
A3/B3
Column 2:
Team 1
Team 2
Team 3
Column 3:
1
2
3
Column 3 is just a ranking from 1-30. So I select all the data in columns 1 and 2 and hit sort from largest to smallest and it looks like excel computes, but nothing changes and it doesn't sort from largest to smallest? Any ideas?
your data already appears to be sorted-can you explain what you think should happen that doesn't?
Josie
if at first you don't succeed try doing it the way your wife told you to
Book1.xlsx
Ok that book is an example. I want to sort Columns D and E. When I hit Sort from largest to smallest, all it does is move team 3 to the 2nd row.
The result should be:
1.33 Team 1
1.25 Team 3
1 Team 2
Am I doing something wrong? It should sort based on values in column D, but column E should not lose its relation to column D.
trouble is col d is calculated and wont sort as it just recalculates whats in the cell a1/b1 but column e does sort with the original values but now has the wrong value next to it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Do you know of anyway to overcome this? Sort based on a calculation?Originally Posted by martindwilson
select ALL the columns a to e then sort by col d descending
That will work thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
nobodyukno 
Register To Reply
Bookmarks