Formula for calculating a sorted list of values

Hi Folks,

I was wondering if anyone can please help me with an issue that I am having as my current way of calculating is not working.

Issue:
I am currently using a pivot to return and populate the required data but this does not refresh correctly and returns zero values every time this report is refreshed. I am therefore hoping that there is a way to calculate this using formulas please.

The following applies:
The attached document has 2 tabs: Date AND Report
The Data tab feeds the report tab
The REPORT tab has 2 reports in it but if you can help me with the first one then I should be able to do the second one. If you look at the first table you will see the data that needs to be populated. I have added a highlighted (in YELLOW) row at the bottom of this table which shows you which columns populate what column

Requirement:
I am after something that will populate this table in a descending order - IE: the figures in the DATA tab Column BE should be sorted from highest to lowest. It must be filtered to the top 30 results only and then all the other columns must be populated.

Column H in the REPORT tab should be formatted to [h]:mm
Column F & G in the REPORT tab should be formatted to dd/mm/yyyy hh:mm

I really hope that someone can help me - it will be greatly appreciated.

Take care,
Andrew

See if this is what you are looking for

I did have to change the formula in Data!BE because negative numbers come first when sorted, I just made them show blank instead of #####. Also I think your contractor should be column N, just noticed.

Hi Hawkeye16,

WOW - you make it seem so easy! Thank you so very much.

How do I get it to go the other way...so that the highest number is on the top?

Much appreciated sir,

Take care,
Andrew