How do i go mirror/invert?

  • Thread starter Thread starter desmond
  • Start date Start date
D

desmond

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?
 
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
 
Back
Top