Hi ,was wondering is there a way to do mirror pastng or not?
Example copy from row with different value 1 , 2 , 5 , 4 and paste to to become 4,5,2,1 ?
thanks .
Hi ,was wondering is there a way to do mirror pastng or not?
Example copy from row with different value 1 , 2 , 5 , 4 and paste to to become 4,5,2,1 ?
thanks .
I don't know of a way to mirror paste. You can enter a formula in your desired range to return the values in 'reverse order'.
Suppose you have the values:
1
2
5
4
8
9
3
6
7
in cells A1:A9. In B1:B2 (insert a blank col B if needed) enter:
9
8
highlight both and drag down to B9 to fill the descending series to 1.
In C1 (or your range of choice) enter the following formula:
=INDEX($A$1:$A$9,B1) and copy down through C9
The results will be:
7
6
3
9
8
4
5
2
1
Of course expand or contract the range to meet your needs.
Will this work for you?
Bruce
The older I get, the better I used to be.
USA
Hi Desmond
There isn't a copy and Paste function to do this. Paste Special>Transpose
will take a copied vertical row and paste it horizontally (in the same
order) or vice versa.
You could use formulae to achieve what you want. For example supposing your
data was in row 5 starting with A5. In cell A6 enter
=OFFSET($A$5,0,COUNTA($5:$5)-COLUMN())
and copy across as far as you require.
Regards
Roger Govier
desmond wrote:
> Hi ,was wondering is there a way to do mirror pastng or not?
> Example copy from row with different value 1 , 2 , 5 , 4 and paste to
> to become 4,5,2,1 ?
> thanks .
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks