Matching columns of data

  • Thread starter Thread starter karlos
  • Start date Start date
K

karlos

is there a way in excel you can sort data but matching 2
columns of data at the same time.

my data has lots of columns but i want to match up 2
columns in particular (to 1 dec place)

so instead of (for example:

13.35 12.10
11.78 10.84
10.84 12.72
12.72 11.78
12.10 13.35


you can sort it cand match the columns up (like this)

10.84 10.84
11.78 11.78
12.10 12.10
12.72 12.72
13.35 13.35


but obviously it must move all the other row data as well

can it be done...if not can it be done in access?

thanks in advance
 
Karlos,

Eh? In the first row, the 10.84 in the left column came from a different
row than did the 10.84 in the right column. So which row should values from
other columns come from?
 
Back
Top