B

#### Bobby

a1 1 a1 5

a2 2 a2 4

a3 3 will look like this a3 3

a4 4 a4 2

a5 5 a5 1

Take #5 and move it up to row a1 #4 move to row a2 #3 stays put, #2 move it

to a4 and #1 move to a5. Can this be done with Excel. I need it simple.

Thanks Bob

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

B

a1 1 a1 5

a2 2 a2 4

a3 3 will look like this a3 3

a4 4 a4 2

a5 5 a5 1

Take #5 and move it up to row a1 #4 move to row a2 #3 stays put, #2 move it

to a4 and #1 move to a5. Can this be done with Excel. I need it simple.

Thanks Bob

P

Descending then OK.

Hope this helps.

Pete

J

From your sample, I would just Sort>Descending but maybe I'm not seing the

full picture.

HTH

John

S

explain how you want to do it using formula or using a single command.

If u want to use it in a command, then copy second column alone and go to

paste special and click transpose. U will get the result.

It's ok for u?

S

Hi Bobby,

Leave my previous post. It will not resolve ur problem.

Shaun

Leave my previous post. It will not resolve ur problem.

Shaun

B

Thanks to all, I got it......

Bob

Bob

B

assending / desending isn't what I'm lookin for.Bobby said:I have a column formatted as text, I want to reverse the numbers around

a1 9 a1 12

a2 5 a2 1

a3 7 will look like this a3 7

a4 1 a4 5

a5 12 a5 9

Thanks Bob

J

I would use a extra column and number them in order starting at the top

after you select both column and you sort descending.

HTH

John

J

John said:

I would use a extra column and number them in order starting at the top

after you select both column and you sort descending.

HTH

John

G

=INDEX(A:A,LOOKUP(2,1/($A$1:$A$65535<>""),ROW($A$1:$A$65535))-ROWS(B$1:B1)+1)

and copy down

G

=INDEX($A:$A,5-(ROW(A1)-1))

Change the 5 to last row number.

Gord Dibben MS Excel MVP

H

....Gord Dibben said:Or if you know what the last row will be, this is easier to type.

=INDEX($A:$A,5-(ROW(A1)-1))

Picky: this only works for ranges that start in row 1. Gary's formula

works for ranges starting in any row.

If the last row is known, and the first row is known, then the whole

range should be known. If so, here's a simplification that works for

ranges starting in any row. For example, if the range were C5:C24,

C5:

=INDEX($C$5:$C$24,ROWS($C5:$C$24))

and fill down.