Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from Jun 13 '11 at 11:09

This question came from our site for professional and enthusiast programmers.

for example: you can copy the values to another column, and sort it – Dr. belisarius Jun 12 '11 at 7:54

You must remove the references to the cells. As belisarius commented, you can copy and paste values over top of the formula cells

Alternately, you can click on the cells with formulas, select the references in the formula bar and hit F9, this will create the formula with absolute values rather than references.

share|improve this answer

You must log in to answer this question.