On Thu, Jul 31, 2008 at 10:28 AM, Mark Knecht <[EMAIL PROTECTED]> wrote: > On Thu, Jul 31, 2008 at 10:20 AM, Anthony Chilco <[EMAIL PROTECTED]> wrote: >> >> >> Mark Knecht wrote: >> >>> >>> In my case, since the values in the X column remain valid for the >>> rotated version I could even accept that these values weren't changed >>> at all, but unfortunately it's a huge amount of work to go back and >>> make every entry $X$64, $X$65, etc. I'll do it if I have to but I'd >>> rather not. >>> >>> Any ideas how I get around this? >>> >>> If this is too complicated to do in words I'll post a small >>> spreadsheet as an example. >>> >>> Thanks, >>> Mark >>> >> Hi Mark, >> As a quick fix, you can use find and replace to change X64 to $X$64. >> tc >> > > Tony, > The X column is >100 deep. I'd rather not start changing stuff that > way as it makes it hard for me to expand the size of that array in the > future, saying nothing about how long it takes to change all those and > debug the 3 or 4 I'm bound to do incorrectly. > > Also, I'm presenting this issue in a pretty trimmed down way. This > spreadsheet is already 14 pages and this sort of issue, potentially > comparing one array against another, is not something that's in there > anywhere. If this one test I'm doing works than I'll have many more > pages to do also. > > Thanks for the input though. I appreciate it. > > Cheers, > Mark >
OK, I'm not sure I like this but I can do it using the array function =transpose(A64:X138) 1 5 2 6 3 7 4 8 gets transformed to 1 2 3 4 5 6 7 8 as a single operation. It works fine but does require that I remember that the area I'm looking at is an array and that I don't mess it up and remember to use Ctl-Shift-Enter. Thanks for the ideas folks, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
