rank - Sorting top 4 ranking by name - Stack Overflow

admin管理员组

文章数量:1022949

I am creating an automated scouting report for a basketball team. I am looking to automatically populate a list of team leaders in a variety of categories. In this case, I am looking at leading point scorers per game.

I have the raw data of who is scoring the most points per game, but I will like to automatically populate the Top 4 scorers and list their jersey number, name, and scoring average.

text

I don't quite know where to begin. I know how to use the rank function, but not to sort on another tab.

I am creating an automated scouting report for a basketball team. I am looking to automatically populate a list of team leaders in a variety of categories. In this case, I am looking at leading point scorers per game.

I have the raw data of who is scoring the most points per game, but I will like to automatically populate the Top 4 scorers and list their jersey number, name, and scoring average.

text

I don't quite know where to begin. I know how to use the rank function, but not to sort on another tab.

• sorting
• rank

Share Improve this question Follow asked Nov 19, 2024 at 4:24 Josh LewisJosh Lewis 1

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

If you work with Excel this formula should return the intended result. Please don't share sensitive data such as names of real people in your files, screenshots or else.

=CHOOSECOLS(TAKE(SORTBY(A2:N13,N2:N13,-1),4),1,2,14)

I am creating an automated scouting report for a basketball team. I am looking to automatically populate a list of team leaders in a variety of categories. In this case, I am looking at leading point scorers per game.

I have the raw data of who is scoring the most points per game, but I will like to automatically populate the Top 4 scorers and list their jersey number, name, and scoring average.

text

I don't quite know where to begin. I know how to use the rank function, but not to sort on another tab.

I am creating an automated scouting report for a basketball team. I am looking to automatically populate a list of team leaders in a variety of categories. In this case, I am looking at leading point scorers per game.

I have the raw data of who is scoring the most points per game, but I will like to automatically populate the Top 4 scorers and list their jersey number, name, and scoring average.

text

I don't quite know where to begin. I know how to use the rank function, but not to sort on another tab.

• sorting
• rank

Share Improve this question Follow asked Nov 19, 2024 at 4:24 Josh LewisJosh Lewis 1

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

If you work with Excel this formula should return the intended result. Please don't share sensitive data such as names of real people in your files, screenshots or else.

=CHOOSECOLS(TAKE(SORTBY(A2:N13,N2:N13,-1),4),1,2,14)

本文标签： rankSorting top 4 ranking by nameStack Overflow