Excel does not sort correctly with formulae

[Phanindra]

Hi Gurus,

Here's a challenge that came my way while working on a report.
I've a supplier name, year, spend which are repititive over a 3 year period (2014, 2015 and 2016).
I've used INDEX, MATCH to create a new list in a separate sheet to get the unique suppliers list. I've used SUMIFS condition to get the spend against each supplier in 3 different columns 2014, 2015 and 2016.

Now, I want to sort the list from "largest to smallest" with the current year "2016". But Excel is not sorting the column 2016 correctly.. I even used a macro to have the file sorted per current year but couldnt succeed.

I'm depending on your mighty brains to have this sorted. Please assist.

P.S. : I'm attaching a part of the huge data set due to size constraints.

 

[vletm]

Could You set 'calculation manual' while sort?

 

[Sara]

How about using pivot tables?
The data wouldn't need the index, match or sum ifs that slow down processing, and sorting becomes simple

 

[Phanindra]

How about using pivot tables?
The data wouldn't need the index, match or sum ifs that slow down processing, and sorting becomes simple

@Sara,
That's an option i tried earlier, but since I have a more than 50 columns in my data set. I have to create many pivots for each condition.
However, Thanks for the solution. I think this is the only way I can be able to do this.