The simple Table object in Figure A duplicates a few names across four columns. Our task is to create a single list of values repeated across any two columns. We’ll start with quarters 1 and 2.

We’ll use data validation to prevent duplicate numbers in the Membership Number column. First, enter the following function into cell K3: =COUNTIF(Table1[Membership Number],B3) ...