Formula to replace pivot table in Excel 2019

Hi experts,

I have the following data and wishes to use a formula to replace pivot table. I googled that I can use the function Unique to do but as my version of excel is 2019, it don't allow me to use this function. Is there any other way? Thanks.

Number Type
4 a
5 b
18 c
17 d
5 e
4 f
12 g
8 h
5 i
15 j
16 k
3 l
3 a
20 b
16 c
19 d
13 e
13 f
19 g
20 h
18 i
7 j
3 k
7 l
4 a
9 b
18 c
11 d
16 e
2 f
17 g
15 h
7 i
4 j
8 k
11 l
16 a
11 b
2 c
18 d
20 e
2 f
16 g
3 h
9 i
17 j
10 k
4 l
8 l

Originally Posted by dflak

I suggest you read up on Excel Tables. There are many good reasons for using them. Take a look at the formulas in Column J. Using header names is one reason. Also as you add data, the formula will not have to change. Tables "know" how big they are.

Hi dflak,

Thanks for replying. Sorry for not making myself clear. What I'm asking is if there's any other way to get the unique values of the numbers in Column I without the use of pivot table? Thanks.