Take the top (or bottom) x number of values from data set with 1 formula!
Timecodes:
0:00 - Intro
0:23 - CHOOSECOLS() - Select specific columns to display
0:49 - SORT() - Choose a column to sort by, Ascending or Descending order
1:15 - TAKE() - Take only the specified quantity from data set
1:38 - Reverse the sort to get the bottom portion of the data set
Visit our business homepage: https://mycostpro.com
Download
0 formats
No download links available.
Excel 365 Tutorial: TAKE top sorted results from data set | NatokHD