marvin jones
Board Regular
- Joined
- Mar 16, 2016
- Messages
- 86
Hi All,
I have the formula below which looks at the smallest 3 values in a pivot table (column CT) and returns with the employee name (column CS)
=IF(ISERROR(INDEX('Bradford - Data'!$CS:$CS,MATCH(SMALL('Bradford - Data'!$CT:$CT,1),'Bradford - Data'!$CT:$CT,0))),"TBC",(INDEX('Bradford - Data'!$CS:$CS,MATCH(SMALL('Bradford - Data'!$CT:$CT,1),'Bradford - Data'!$CT:$CT,0))))
However, this formula returns with the same name 3 times. I don't have this issue when applying the LARGE formula.
Is this to do with there being a series of no values in the pivot column (due to the employee not working)?
What is an alternative formula to get the smallest values?
Thanks,
I have the formula below which looks at the smallest 3 values in a pivot table (column CT) and returns with the employee name (column CS)
=IF(ISERROR(INDEX('Bradford - Data'!$CS:$CS,MATCH(SMALL('Bradford - Data'!$CT:$CT,1),'Bradford - Data'!$CT:$CT,0))),"TBC",(INDEX('Bradford - Data'!$CS:$CS,MATCH(SMALL('Bradford - Data'!$CT:$CT,1),'Bradford - Data'!$CT:$CT,0))))
However, this formula returns with the same name 3 times. I don't have this issue when applying the LARGE formula.
Is this to do with there being a series of no values in the pivot column (due to the employee not working)?
What is an alternative formula to get the smallest values?
Thanks,