Forums Últimos mensajes - Powered by IBM
 

How to reverse values in excel?

14/05/2010 - 08:33 por Denish D | Informe spam
I have values in a column like:

546
3242
54
5645
257
245
1565


i Want to make them in reverse order as :

1565
245
257
5645
54
3242
546

Can any one help me...
 

Leer las respuestas

#1 Héctor Miguel
14/05/2010 - 08:45 | Informe spam
hi, Denish !

- values in [A1:A7]

- [B1] =index(a$1:a$7,rows(a$1:a$7)-row()+1)
- copy/drag down up to [B7]

hth,
hector.

__ OP __
I have values in a column like:

546
3242
54
5645
257
245
1565

i Want to make them in reverse order as:

1565
245
257
5645
54
3242
546

Can any one help me...

Preguntas similares