I am getting repeats when there should not be any. Here are the formulas and
below is a portion of the worksheet. You can see hhow the Section and Work
Order are repeating. It should only show a one time entry.

=IF(ISERROR(SMALL(Overall!$AP:$AP,ROWS(A27:$A$29)) ),"",INDEX(Overall!AI:AI,MATCH(SMALL(Overall!$AP:$ AP,ROWS(A27:$A$29)),Overall!$AP:$AP,0)))

=IF(ISNA(MATCH(A2,Overall!AI:AI,0)),"",INDEX(Overa ll!A:A,MATCH(A2,Overall!AI:AI,0)))

Section Work Order
00910 OK00021
20380 OK00017
29025 OK00002
20380 OK00017
00910 OK00021
13301 OK00022
20380 OK00017
13001 OK00008
13001 OK00008