PDA

View Full Version : Linking cells, sorting by values in column



jdilts
11-05-2012, 12:55 PM
Hi,

I want to have cells linked, so when I do a numeric sort on a column those numerical values stay associated with their partnered cell.

For example

C1 C2
jeri 3
matt 1
una 2
harrison 4

How can I sort column 2 numerically and have C1's result be matt, una,jeri,harrison?

Thanks!

GreenDR
11-06-2012, 12:15 PM
select data
right click-> sort -> custom sort
Sort By: C2
Sort On: Values
Order: Smallest to Largest

jdilts
11-08-2012, 12:02 PM
Thanks