|Posted by:||Dave Morison (davesexc…@gmail.com)|
|Date:||Sat, 14 Mar 2009|
Jan Kronsell wrote:
> I have made a spreasheet for a friend. I G11 I have this fomula:
> end from G12 to G21 I have
> 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?
The content in the cells are sorted not the cells themselves.
Sorting posted by Jan Kronsell on Sat, 14 Mar 2009