Excel's top tips! Showing Top 3 data
Technique for displaying only the Top 3 data (can also be adjusted to Top 5 or Top 10 🙂)
This clip is really cool!
It uses new functions in Excel 365 to perfectly integrate them.
If you like this clip, please leave a comment 😊
-------------------------
Note 1: The first formula used is:
=TAKE(SORT(A2:B15,2,-1),3)
-------------------------
Note 2: The last formula used is:
=LET(_data,SORT(A2:B15,2,-1),
_topN,TAKE(_data,H1),
_othAmt,SUM(DROP(_data,H1,1)),
_others,HSTACK("Others",_othAmt),
_total,HSTACK("Total",SUM(B2:B15)),
VSTACK(_topN,_others,_total))
#exceltricks #worksmart #engineerreport