Small/Large () without repeating the same value in each list

[ExcelBasicBro]

I am creating two lists. List one is the Top 5 and the second list is the bottom 5. I am pulling the data from the same data set. I get can return both the Large() and the Small() but if the data has less than 10 items to start, it ends up repeating of the values on the both lists. I'd like to avoid that if possible. Any ideas on how to say if a value shows up on the Top 5, do not put it on the bottom 5?

 

[jasonb75]

Using the dynamic array functions in office 365,

Book1 (version 1).xlsb
	A	B	C	D	E
1	Original		Top 5		Bottom 5
2	1		9		1
3	2		8		2
4	3		7		3
5	4		6		4
6	5		5
7	6
8	7
9	8
10	9
11
Sheet3

Cell Formulas
Range	Formula
C2:C6	C2	=IFERROR(LARGE(A2:A21,SEQUENCE(5)),"")
E2:E5	E2	=IFERROR(SMALL(A2:A21,SEQUENCE(MIN(5,COUNT(A2:A21)-5),,1)),"")
Dynamic array formulas.

 

[ExcelBasicBro]

That worked! Thank you!