I need to be able to index the name column on a separate tab and remove all duplicated results. I've already spent WAY too much time trying to figure this out... all the great excel minds in my office were stumped with this one.
=INDEX('Audits and Scores'!A1:R4180,,6) - This is as far as I was able to make it, in terms of indexing.
And this is where I ended up with removing the duplicates but this formula doesn't work and I can't figure out why -
=INDEX('Audits and Scores'!F2:F39,,SMALL(IF(MATCH('Audits and Scores'!F2:F39,'Audits and Scores'!F2:F39,0)=ROW(INDIRECT(“1:”&ROWS('Audits and Scores'!F2:F39))),MATCH('Audits and Scores'!F2:F39,'Audits and Scores'!F2:F39,0),””),ROW(INDIRECT(“1:”&ROWS('Audits and Scores'!F2:F39)))))
If anyone could point me in the right direction it would be much appreciated
Bookmarks