Get the TOP 4 Teams Sorted based on Percentage and Add Rank Column Excel 365
How to Get the TOP 4 Teams Sorted based on Percentage Column & Add Rank Column in Microsoft #Excel 365? Example: ICC World Test #Cricket Championship 2023 - 2025
=TAKE(HSTACK(
SEQUENCE(ROWS(Data[Teams])),
TAKE(CHOOSECOLS(
SORT(Data,6,-1),1,6),9)),4)