My lazy way to pull the Top 3 rows in Sheets and keep them sorted
I needed a quick Top 3 list for a weekly update. I used FILTER + LARGE, then SORT on top. I grabbed anything >= the 3rd largest value, then sort the result descending. This is the first time nesting formulas felt like it actually reduced work. And now if someone updates the sales numbers, the list updates automatically.
0 Comments