Hi, I have a list of name entries (some duplicated) in column A from A2 to A20, in column B next to certain entries I haver the number 1 to signify dues paid.

I am looking to create a unique list in column C that lists the names with the 1 beside them, only 1 instance of the name in column A has a 1 next to it at any time.

Looking to do this without a pivot table or an array formula.

Looking forward to the answer.

Cheers

JD