OfficeSuite Pro sort problem! Need Help!

[skyhark]

Hi there,

I load a excel file from PC directly then run a simple caculate within my Android phone and sort by a column whatever text or numeral column but the result are mess and appear #REF! within all caculate fields

Is there anyone has same exterience and how to resolve?

Thanks anyway

 

[wyelkins]

Sounds like your formula references cells in a different row than the one it is in, but both are in the sort range. You may have to convert the column with the formula into values before sorting. This can be inconvenient if you need the formula to recalculate later. I have this problem sometimes when I have a column of numbers and need a "running total" usually a cumulative percentage adding up to 100%.

The formula may instead be referencing a cell as relative instead of absolute where the cell is outside of the sort range, but this sounds unlikely.

Sorry if I am missing the point entirely.

 

[skyhark]

Hi, wyelklins,

I understood what your meaning, please check my processes for me and let me know what I need to correct
1. choose column 2 let this column highlight
2. Edit => Start selection
3. choose end column you want to sort and let area highlight
4. Edit => Sort => Sort by column: B and Sort order AZ then "OK"

Is ther any different with your process?

Thanks,