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

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

I tried opening the file and got also an error message.

Tried to download the file, but it changed in a txt file, and nothing appears.

So there might be something wrong?

Frans

Not sure what happened but I have reattached the file so you should be able to download it now.

Philip Treacy said
Not sure what happened but I have reattached the file so you should be able to download it now.  

Hai Phil..

Thanks for attached file.. very appreciated..