Hello everyone,
Not sure this is should be in the programming section, but still I wonder if there is any easy way to copy numbers and then paste them backwards.
Like I have these numbers:
1
2
3
4
5
And I want to copy-paste them just like this:
5
4
3
2
1
The thing is, I have 6331 numbers like that, so I can't do it manually.
Any help will be appreciated.
Last edited by rogerthatman; 07-19-2012 at 08:17 AM.
In next column write: =INDEX($A$1:$A$6331, COUNT(A1:A6331)) and extend formula down.
Then you can copy this column and paste values
Never use Merged Cells in Excel
Thank you very much!
But the thing is, that I have couple of numbers. So how I should do it then?
It actually looks like this:
1 3 5
2 4 6
3 4 3
and so on..
and opposite you want:
Please Login or Register to view this content.
So you can write in next free column (or on other sheet):
=IF(A1="", "", INDEX(A$1:A$6331, COUNT(A1:A6331)))
Well, yes, but it's not only on the A column, but also B and C.
Hi
try this code and data is in sheet1 and pasting into sheet2 change according to your r equirement
Please Login or Register to view this content.
Doesn't matter... Pull formula down and rightOriginally Posted by rogerthatman
No, nothing works.
zbor, you just gave me a counting formula, it's far away from what I need.
did you even try it?
Well, it did work. thanks. but in a column of dates it doesn't work. For instance, like this:
11/11/2010
12/12/2011
04/09/2004
And I want them also with a reverse copy-paste value, but your formula doesn't work with them.
Last edited by rogerthatman; 07-19-2012 at 05:40 AM.
have you tried my code ? If not , see the attachment and run code and your desired output will be in sheet2.
A column of dates worked fine for me with zbor's function
What do you mean by doesn't work?
Everything works great, thanks a lot zbor!
But now I'm facing a new problem: I'm trying to copy the numbers I got into a different excel file, but instead, it copies me the formula.
Is there anyway to avoid it and copy actually the exact numbers?
Copy -> Paste spetial and choose: Values
Thank you so much. Everything is working great now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks