Sorting

  • Thread starter Thread starter Jan Kronsell
  • Start date Start date
J

Jan Kronsell

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
 
Jan said:
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
Click to expand...
The content in the cells are sorted not the cells themselves.
 
I know that its the content, that is is sorted .-).

But then I change my question:

Is it possible to change my formula:

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

so it stills points to the cells, where the content of present G11, E12 and
F12 "ends up" after a sort?

Jan
 
Back
Top