Excel help

Guv · 27 May 2006 at 17:03

I have a table, 4 rows, 5 colums.
Columns one and five have actual data in them, all other cells in colums 1, 2 and 3 use formulas.

I want to sort all data in the table by column 5. When I do this by clicking, data, sort, by column 5, descending order, it changes columns 1 and 5 but isn't moving the fomulas from the other cells.

Is there any way I can make it move all the row, be it data or formula, when I do a 'sort'?

thanks

ironhorse · 27 May 2006 at 17:37

are you highlighting all 5 columns? then sorting by column 5

Guv · 27 May 2006 at 17:38

ironhorse said:
are you highlighting all 5 columns? then sorting by column 5

yes

ironhorse · 27 May 2006 at 17:42

are the formulas absolute i.e $A$1*$A$2

or normal i.e A1*A2

Guv · 27 May 2006 at 17:45

ironhorse said:
are the formulas absolute i.e $A$1*$A$2

or normal i.e A1*A2

They are 'if' formulas, just normal though, not absolute.
I'll try adding the '$' to them.

thanks

whitecrook · 27 May 2006 at 20:03

TTIUWO(the excel spreadsheet in question)