Hi

If my previous posts didn't give an answer to your question, then I guess that I simply don't understand what your question exactly means.

If you mean with "live results" only values, but not cell-references, then, obviously it is not possible with formulas. Perhaps it is possible with a script, but I don't know anything about scripts.

However, if you mean something else, and you want to get it, using formulas, then, again, I advise you to share an example spreadsheet with us. If it can be done using formulas, although I might not be able to provide the desired results, then we have always Yogi and Adam, who are masters in spreadsheet-formulas.