

July 16, 2010

Hi Azri,
I'm afraid your problems are caused by the wrong source data layout. Ideally your data should be in a tabular format because this makes it easy to analyse and summarise with formulas and PivotTables.
In the attached file I used Power Query to fix the layout of your data (see the correct layout on the sheet called 'Tabular Layout').
I then used PivotTables to summarise the data into the bottom 5 results for each period.
I hope that points you in the right direction. Adopting this best practice for your source data layout will simplify your Excel life and result in more robust workbooks that aren't hanging on an array formula thread.
All the best,
Mynda


March 26, 2018

Hai Mynda..
Thanks for fast feedback, but just want to inform you that I can't download attachment had you provided above..
When I click the attachment web say " Sorry, the page you are looking for cant't be found".
Hopefully can fix it soon.
Thanks and best regard..
Adrin

VIP

April 21, 2015

1 Guest(s)
