TAKE/SORT Formula help

[Sunshine8790]

Hi!

I'm trying to create a top 20 leaderboard from another tab on my spreadsheet.
I'm utilizing the Take/Sort formula combo to get results, and it's working fine with the data, however I need help adjusting it for these needs:

1. I need the formula to only select results if column A on the table I'm pulling from contains the word "Salary" because I don't want "Hourly" data pulled for this leaderboard.
2. Currently, it is showing all the data from the table range I indicated to pull from. I only need 3 cells of data from each row:
   1. I need data from column T first, column B second, and column S 3rd.
   2. I do not want any other data displaying.

This is what it currently looks like:

Book 11.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	20	TOP 20: JULY
2		Rank	Name	Total Steps
3		Salary	Name 42	1	37527	0	0	0	0	0	0	0	0	0	0	0	0	0	0	37527	1
4		Salary	Name 32	1	30818	0	0	0	0	0	0	0	0	0	0	0	0	0	0	30818	2
5		Salary	Name 43	1	30132	0	0	0	0	0	0	0	0	0	0	0	0	0	0	30132	3
6		Salary	Name 40	1	28167	0	0	0	0	0	0	0	0	0	0	0	0	0	0	28167	4
7		Salary	Name 48	1	20940	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20940	5
8		Salary	Name 31	1	17993	0	0	0	0	0	0	0	0	0	0	0	0	0	0	17993	6
9		Salary	Name 22	1	14322	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14322	7
10		Salary	Name 10	1	13841	0	0	0	0	0	0	0	0	0	0	0	0	0	0	13841	8
11		Salary	Name 36	1	8783	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8783	9
12		Salary	Name 4	1	6208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	6208	10
13		Hourly	Name 3	1	4989	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4989	11
14		Salary	Name 52	1	3440	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3440	12
15		Hourly	Name 13	1	2742	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2742	13
16		Salary	Name 47	1	479	0	0	0	0	0	0	0	0	0	0	0	0	0	0	479	14
17		Salary	Name 1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
18		Salary	Name 2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
19		Salary	Name 5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
20		Salary	Name 6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
21		Salary	Name 7	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
22		Salary	Name 8	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23
Leaderboard

Cell Formulas
Range	Formula
B3:U22	B3	=TAKE(SORT('July Steps (Practice)'!A2:T100,20,1),A1)
Dynamic array formulas.

This is what I need it to look like, and again with only pulling from rows on the other tab that say "Salary":

20	TOP 20
Rank	Name	Total Steps
1	Name 42	37527
2	Name 32	30818
3	Name 43	30132
4	Name 40	28167
5	Name 48	20940
6	Name 31	17993
7	Name 22	14322
8	Name 10	13841
9	Name 36	8783
10	Name 4	6208
11	Name 3	4989
12	Name 52	3440
13	Name 13	2742
14	Name 47	479
15	Name 1
16	Name 2
17	Name 5
18	Name 6
19	Name 7
20	Name 8

Any help is appreciated.

 

[Fluff]

How about

=TAKE(SORT(FILTER(CHOOSECOLS('July Steps (Practice)'!A2:T10020,20,2,19),'July Steps (Practice)'!A2:A10020="Salary")),A1)

 

[Sunshine8790]

=TAKE(SORT(FILTER(CHOOSECOLS('July Steps (Practice)'!A2:T10020,2,19),'July Steps (Practice)'!A2:A10020="Salary")),A1)

I edited it a little and it works! Thank you so much !

=TAKE(SORT(FILTER(CHOOSECOLS('July Steps (Practice)'!A2:T10020,20,2,19),'July Steps (Practice)'!A2:A10020="Salary")),A1)

 

[Fluff]

You're welcome & thanks for the feedback.