Forum Discussion
Exel
Hmmm....what you say is not my experience.
Here's a very simple example. On sheet 1 I've entered a random series of numbers.
Sheet 2 contains a reference to cell C6 on sheet 1, and that reference includes the sheet name
If you sort the array on sheet 1 into numerical order, the reference continues to refer to C6, which now has different content.
This is I think the problem that the OP was referring to. What I see you as saying is that it doesn't happen if the sheet name is included, but it necessarily IS included when it's on a different sheet. For that matter, it happens on the same sheet as well, where sheet name is not part of the reference.
So help me decipher your disagreement. Or are we saying the same thing in different ways and somehow misunderstanding one another.
I HAVE also experienced difficult and confusing results when sorting a table with formulas in the table itself.... so it may be that I share your very pet peeve.
Apologies. We appear to have indeed misunderstood each other. I was referring to the behaviour with respect to formulas which form part of the table being sorted, not to formulas external to that table.
Regards