Alas, it did not perform as needed. I believe I might need to explain more in detail.

The formula I need will have to scan through column 'A' and find only unique work order numbers, it will skip duplicates. Once it has found a unique number in column 'A', it will then look at column 'B' for a yes or a no. It will then count the number of times yes or no appears in column 'B'. If a number is repeated in column 'A', it will disregard the duplicates and count one time from column 'B'
Column'A' Column 'B
W.O. # Complete Pkg
90458179 Yes
90458179 Yes
80053785 Yes
80053785 Yes
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90457063 No
90458387 Yes
90455286 No
90455138 Yes

The formula will only look at number, 90457063, once and count one 'No' in column 'B'. It will only count the number of Yes or No's one time regardless of the number of times the number appears in column 'A'

The totals shoudl read: Yes = 6 and No = 2

Hope this helps to clarify what I am needing. I am also stuck using Excel 2003..