Hello,
I have two tables that both contain variables "participant sequence number" (value: 1-10000) and "participant group number" (value: 1-4). The sample of two tables are the same, so "participant sequence number" are same in two tables, but the methods of grouping are different, so their corresponding "participant group number" may be different between two tables.
I want to know how many participants that are included in the same group are in both tables? (for example, how many participants that are included in group 1 in the first table, and also included in group 1 in the second table) .
Could you tell me how to do this?
Thanks in advance.
... View more