How to report the top 20 and bottom 20 of a data table? + report with 2 conditions
Hi community.
I use the workbook "Dashboard". I work on the worksheet "GLOBAL".
I try to establish 3 report.
First report: Top 20 values (end user price in EUR) of the data table located Raw data
This report works but it doesn't work for the bottom 20 values.HTML Code:
Second report. Bottom 20 values (end user price in EUR) of the data table located Raw data
Third report: Values for AMERICA and AntennaHTML Code:
Thank you for your help.
Last edited by Luu4466; 12-10-2020 at 10:53 AM.
What do you mean by "It doesn't work"?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please try
=INDEX(SORT(FILTER('Raw data'!$A$2:$J$897,'Raw data'!$J$2:$J$897>0),10),SEQUENCE(20),SEQUENCE(,10))
and
=SORT(FILTER('Raw data'!$A$2:$J$897,('Raw data'!$B$2:$B$897="Antenna")*('Raw data'!$H$2:$H$897="America")*('Raw data'!$J$2:$J$897>0)),10,-1)
Please update your profile. You are clearly not using Excel 2016.... which (I believe) did not support SEQUENCE.
It works but i have only the blank value which are reported. (I think blank values are considered as a 0, and 0 are small values)Originally Posted by Glenn Kennedy
I am using version 2002 (Build 12527.21330) version.
[QUOTE=Bo_Ry;5436960]Please try
=INDEX(SORT(FILTER('Raw data'!$A$2:$J$897,'Raw data'!$J$2:$J$897>0),10),SEQUENCE(20),SEQUENCE(,10))
and
=SORT(FILTER('Raw data'!$A$2:$J$897,('Raw data'!$B$2:$B$897="Antenna")*('Raw data'!$H$2:$H$897="America")*('Raw data'!$J$2:$J$897>0)),10,-1)[/QU
It's working, thank you very much Bo_Ry. I'm learning so fast with your help!
Last edited by Luu4466; 12-10-2020 at 08:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks