Log In
Register
Home
March 26, 2018
Offline
Hai admin..
I have are problem regarding return value keep repeating due range value is duplicate.
here is attached sample workbook to you identify that particular problem.
Relay need help some one to give the right method / formula to resolve the problem.
July 16, 2010
Offline
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
Offline
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
Offline
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
1 Guest(s)
