Hi,

I have in (A1:A25) 25 names of 25 different persons and in (C1:C50) 50 names of 50 different persons.

With which formula could I regroup all those persons, without duplicate, in column E knowing that some persons may appear in A and C and some other persons appear either in A or C

Many thanks