Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
91
Views
Topic starter
Require the name of top 10 Companies by classification (High/Low) with highest amount.
I solved with filter/transpose with helper column.
Please suggest an alternative.
Once, that is solved I'd like to apply another condition 'By Sector'.
Spreadsheet attached for reference.
Posted : 24/02/2024 11:17 am
Hello,
See if attached file works for you, using INDEX, SORT, SEQUENCE and FILTER functions. I haven’t checked for tie amount values, might need adjustments to handle such scenarios.
Br,
Anders
Posted : 24/02/2024 9:34 pm
Topic starter
Thanks @Anders Sehlstedt, appreciate your solution+reply.
I am wondering, how in the world, I couldn't think of 'Sort' outside filter. Possibly, I was trying to get the output mainly by adding 'conditions' within filter only which got me stuck and ended up adding helper.
Posted : 25/02/2024 1:26 am
