find the best 3 values with multiple variables

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

Originally Posted by gmr4evr1

Check the attached to see if it is even close to what you want...
Attachment 465457

Yes Exactly! The thing is when I input the same formula on my excel file, it shows a "#NUM!" error. (also did you manually have to adjust the formula for each person, I have a very large dataset,so do you know if there is any way around this?

Ok thanks for your help! I guess its time to slave away at those numbers