how to paste the values in reverse order in workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
after copying the cells, how to paste the copied cells in reverse order
ex: 1
2
3
i want to paste these cells in this order
3
2
1
 
It would be best to sort the number in descending order
after you paste the copied data.

Rojee
 
this solution was given by an MVP(sorry I forgot to note the name)
suppoe your data is in B1 to B16

in some other cell(e.g. D12) type this formula

=OFFSET($B$1,MATCH($B$16,B1:B16,0)-1,0)

copy d12 down till #N/A appears. Remove cells containing ""N./A""
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
Back
Top