How do you invert the columns in excel.
Ex: the column is
2
3
4
5
and I want it inverted to
5
4
3
2
HElP much needed.
Thanks
Answers: If your notes are not irregular lay down, you can use sort resembling the previous answers, but
If your information are unsystematic charge (irregular),
example:
a
z
x
p
You want to be similar to this:
p
x
z
a
Write at Cells A1 to A4 respectively 1,2,3,4
Write at Cells B1 to B4 respectively a,z,x,p (your data)
Write at Cells D1 to D4 respectively 4,3,2,1
Write at Cells C1
"= VLOOKUP ( D1 , $A$1:$B$4 , 2 , inaccurate )"
drag this formula until accomplish cell C4 or copy it from C1,
later you will win inverted decree at C column!
1 | a | p | 4
2 | z | x | 3
3 | x | z | 2
4 | p | a | 1
------------------------
Highlight info consequently Data/Sort/decending...