I am having trouble knowing how to obtain the 3 smallest numbers within a range, but from multiple variables. For Example, I made a pivot table that has the following structure, but I am unable to use the "SMALL" function for some reason, and if its possible, how can I formulate it so that I can drag the formula for each person given the ranges for each person are of multiple sizes and this is a very big dataset. If there is another way for me to be able to get the 3 smallest value for each person (all people have unique identifiers) please let me know how I can achieve this. Thank you!

Year X
Person 1
10
12
12
14
15
Person 2
34
31
23
43
12
Year XI
Person 5
23
34
12
Person 6
2
1
23