Sorting

Giganews Newsgroups
Subject: Sorting
Posted by:  Jan Kronsell (kronsell(nomorespam)@adslhome.dk)
Date: Sat, 14 Mar 2009

I have made a spreasheet for a friend. I G11 I have this fomula:

=IF(I11="paid",B7-E11+F11,B7)

end from G12 to G21 I have

=IF(I12="paid",G11-E12+F12,G11)

Now my friensd tries to sort the range from A11 to L21. based on column G,
but this of coourse messes up the results in columns G, creating #VALUE!.
messages in some cells, and wrong results in other.

Is there anyway to create the formulas, so you can sort the spreadsheet, and
still have the formulas pointing at the right cells?

Jan

Replies