Hi guys, Some of you helped me out in the past by creating this formula, and now I'm trying to alter it to fit another circumstance.

=IF(ROWS(AW$3:AW3)>COUNTIF($AF$3:$AF$848,"100%"),"",INDEX($B$3:$B$848,SMALL(INDEX(($AF$3:$AF$848="100%")*(ROW($AF$3:$AF$848)-ROW($AF$3)+1),),COUNTIF($AF$3:$AF$848,"100%")+ROWS(AW3:AW$3))))

It's supposed to create a list of the names of people with %100, but instead it's listing the first person for every person that has 100%.

For example, if two random people have 100%, the first two people on the list are generated. If three random people have %100, the first three people will be listed. I would like my generated list to show only those who have %100.

A dummy sheet is attached.

dummy 10.xls

Thanks in advance!