cookeetree
Board Regular
- Joined
- Mar 2, 2015
- Messages
- 53
G'day Excel Gods,
I have a table showing Training Courses, the Employee who completed it and the date they completed it.
On a separate worksheet, there is a formula that searches through this table to find those employees who've completed a specific course ($B$1).
{=IFERROR(INDEX('Training Completed'!$G:$L,SMALL(IF('Training Completed'!$G:$G=$B$1,ROW('Training Completed'!$G:$G)),ROW(1:1)),5),"")}
However, where an employee has completed a course multiple times, I see their name multiple times.
How can I modify (or rewrite) the formula to show only unique names?
Cheers, Jason.
I have a table showing Training Courses, the Employee who completed it and the date they completed it.
On a separate worksheet, there is a formula that searches through this table to find those employees who've completed a specific course ($B$1).
{=IFERROR(INDEX('Training Completed'!$G:$L,SMALL(IF('Training Completed'!$G:$G=$B$1,ROW('Training Completed'!$G:$G)),ROW(1:1)),5),"")}
However, where an employee has completed a course multiple times, I see their name multiple times.
How can I modify (or rewrite) the formula to show only unique names?
Cheers, Jason.