how to paste the values in reverse order in workbook
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 -----Original Message----- 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 . |
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"" ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ nayeemoddin wrote in message ... 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 |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com