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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
