06-21-2021, 07:17 PMKeven Wrote: Don't mind me just need an appropriate place to test the output of my table-generating excel formula.

Rank	Name	Pos	Team	Avg Draft	Min	Max	% Taken
1	Lyle Odelein III	LD		1.026	1	2	100.0%
2	FR Finn-Rhys	RD		3.421	2	8	100.0%
3	Nicholas Owens	LD		4.237	2	12	100.0%
4	Theo Morgan	LW		4.447	2	10	100.0%
5	Adam Barron	LD		6.132	1	11	100.0%
6	Samuel Michaud	RD		6.211	2	11	100.0%
7	Aron Hernadivic	LW		7.079	2	13	100.0%
8	Aaron Wilson	C		8.711	3	20	100.0%
9	Augustus Wang	RD		9.632	4	18	100.0%
10	Hugh Jazz	LD		11.211	5	20	100.0%
11	Elijah Jones	RW		12.842	3	24	100.0%
12	Matt Kholin	C		14.289	7	26	100.0%
13	Alexander Wachter	RW		19.132	9	41	100.0%
14	Keith Lee	RD		19.868	7	50	97.4%
15	Martijn Westbroek	C		20.474	8	50	97.4%
16	Texas Renegades	G		23.868	12	50	97.4%
17	Hamilton Steelhawks	G		24.289	10	50	97.4%

Rank	User	Avg Roster Desirability
1	NorwegianDemon	18.610
2	JumpierPegasus	19.189
3	RedCapeDiver	19.425
4	Sivart	19.895
5	Festinator	20.390

Rank	Team	Unique Selections
17		13
18		12
19		9
20		1

i will marry you, keven.
Are you copypasting intermediate cells like I am or do you have something fancy?