I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table:
For instance, the value of the first cell in the last column in the second table
= (=F4), so it references
F4 cell which exists in the first table, the value of the second cell down
= (=F14), the third one
= (=F19), and so on.
As a result, the last column in the second table will sort incorrectly (false result). Is there a solution to this problem ?
thank you in advance.