Selecting values...

[Guest]

Hello.

I have a function that requires a string of cells, from the most current
month backwards, but when I attempt to select the values from right to left
(because this is the way the data is fixed on the source document), the
selection still shows the cell selection as left to right, so I have to copy
the data onto a separate sheet and manipulate the data so the function will
work properly.

Q - is there a way in Excel to select values from right to left so that the
reference indeed will read right to left, i.e. data in cell b2:b7 to read
b7:b2?

Thanks,
NWO

 

[Guest]

There's not a built-in function to do that that I'm aware of (and every time
I say that, someone comes along later and makes me aware of such <g>). You
can copy and Paste Special with a "transpose" action, but that only turns the
data on its edge, not reversing it.
What you could do, I suppose is do your copying to the new sheet then add a
row of numbers above or below it in sequence as 1,2,3,4,5,6...
and then choose both rows and use Data Sort in Descending order by that
sequence of numbers to get them reversed relatively quickly. The Sort
function does have a Left to Right option so that you can sort this way
rather than the usual vertical sorting done.
Actually, you could probably do that on the source sheet, add the row of
numbers, sort the group, copy the data, then reverse the sort to get things
back in their original order.

 

[Gord Dibben]

B2:B7 is down a column not left to right.

What are the actual cells you wish selected right to left?

Maybe G2:B2?

What do you want done with those cells?

Excel by default will not look at a selection of cells from right to left.


Gord Dibben MS Excel MVP

 

[Guest]

Ooppss...I meant to say c2:f2, and have the cell reference show as f2:c2 in
the function - is hti spossible?

 

[Gord Dibben]

See Jerry's post about a helper row and sorting to reverse the cells.

Or reverse them in a helper row using

=INDEX($C$2:$F$2,4-(COLUMN(A2)-1))


Gord