Okay, I have a bit of a difficult problem. I'm using excel to make a map for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that for
example 13,100 doesn't get you to row 13 and column 100, but to column 13 and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!

It isn't clear what formula you are using, but there should be a number of
alternatives.
One choice would be just to swap the order of your parameters.
Another might be to use the TRANSPOSE function.
--
David Biddulph

"Xane" wrote in message
...
Okay, I have a bit of a difficult problem. I'm using excel to make a map
for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that
for
example 13,100 doesn't get you to row 13 and column 100, but to column 13
and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!

How are you addressing the cells? In a formula, in VBA code? If a formula,
give us an example.

"Xane" wrote:

Okay, I have a bit of a difficult problem. I'm using excel to make a map for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that for
example 13,100 doesn't get you to row 13 and column 100, but to column 13 and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!

Let me try to clarify the problem:

The map I'm working with has a coordinate system that is inversely set up
compared to excel's, meaning that every length coordinate on the map is a
width coordinate in Excel and vice versa.

What I'm trying to do, is take the coordinates of the game map and use them
to fabricate my own map in excel. I'm not trying to calculate anything or use
any formulas. I just want to use all the cells of the map to simulate all the
spaces on the map and enter a name or some text and a colour.

However, since the coordinate system of the game has the X and Y axis
switched, my map would come out tilted 90 degrees if I were to make this map
with the coordinates I take from the game (top would be left, left would be
bottom, etc), which of course is not very practical. I could tell everyone to
print the map, but that would be a huge puzzle and simply undoable, not to
mention that it'll need to be updated constantly.



In short... I just need to somehow rotate my worksheet 90 degrees
counterclockwise...





"David Biddulph" wrote:

It isn't clear what formula you are using, but there should be a number of
alternatives.
One choice would be just to swap the order of your parameters.
Another might be to use the TRANSPOSE function.
--
David Biddulph

"Xane" wrote in message
...
Okay, I have a bit of a difficult problem. I'm using excel to make a map
for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that
for
example 13,100 doesn't get you to row 13 and column 100, but to column 13
and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!


.

Oh, this is Xane btw, I just changed my screen name.

If you've got X and Y transposed, then you don't just have a 90 degree
rotation, but you've also got a reflection, in that a clockwise turn becomes
anti-clockwise.
It sounds as if you need to copy your data, then Edit/ Paste Special/
Transspose.
--
David Biddulph

"Mdegraaf" wrote in message
...
Let me try to clarify the problem:

The map I'm working with has a coordinate system that is inversely set up
compared to excel's, meaning that every length coordinate on the map is a
width coordinate in Excel and vice versa.

What I'm trying to do, is take the coordinates of the game map and use
them
to fabricate my own map in excel. I'm not trying to calculate anything or
use
any formulas. I just want to use all the cells of the map to simulate all
the
spaces on the map and enter a name or some text and a colour.

However, since the coordinate system of the game has the X and Y axis
switched, my map would come out tilted 90 degrees if I were to make this
map
with the coordinates I take from the game (top would be left, left would
be
bottom, etc), which of course is not very practical. I could tell everyone
to
print the map, but that would be a huge puzzle and simply undoable, not to
mention that it'll need to be updated constantly.



In short... I just need to somehow rotate my worksheet 90 degrees
counterclockwise...





"David Biddulph" wrote:

It isn't clear what formula you are using, but there should be a number
of
alternatives.
One choice would be just to swap the order of your parameters.
Another might be to use the TRANSPOSE function.
--
David Biddulph

"Xane" wrote in message
...
Okay, I have a bit of a difficult problem. I'm using excel to make a
map
for
a game I'm playing. I've already converted the columns to numbers as
well,
however the game's mapping system is inverted from Excel's, meaning
that
for
example 13,100 doesn't get you to row 13 and column 100, but to column
13
and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!


.