Sorting Table of Formulas

[AlexLeeds]

https://drive.google.com/open?id=0B7X5e_N0aRshSUthVkNZdXZLUmc

Hi all,

Link above to excel file in question.

The first sheet is simply a table of data - in this case business done with organisations, and the monetary values.

Sheet two is an analysis sheet which totals the number of work pieces and their value with each client.

I want to be able to use the standard table filter options to sort by size - though can't get it to work - as the table is full of formula rather than raw data.

How do I make the sorting work?

Many thanks,
Alex

 

[sergioMabres]

Hi Alex
The problem is that 2017 Figures table column B was created to obtain its value by the row number, so you can not change row number with a sort.

Here are some options:
1. Change column B to get id some other way
2. Copy the 2017 Figures table and paste its values to another sheet, and with this table do as you wish

Cheers
Sergio