Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
    
for example: you can copy the values to another column, and sort it –  belisarius Jun 12 '11 at 7:54
add comment

migrated from stackoverflow.com Jun 13 '11 at 11:09

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

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.