View Single Post
  #2  
Old November 17th, 2009, 08:56 PM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
 
Posts: 8,714
Default Make Excel see columns as rows and rows as columns

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!