Regroup

[akalien]

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

[MarvinP]

Hi akalein,

I'd put the entire list in a new column. That is I'd copy the list in column A to Column E and then copy the list in Col C under the list in Col E. Then I'd do an Advanced Filter with the Unique box checked.
see http://www.contextures.com/xladvfilter01.html for what I'm thinking.

[Fotis1991]

..Or put all your Names in Column A(Starting in A2)--NOt in A1 and use this Array formula in D2 and copy down.

=IF(ISERROR(INDEX($A$2:$A$100;MATCH(0;COUNTIF($B$1:B1;$A$2:$A$100);0)));"";INDEX($A$2:$A$100;MATCH(0;COUNTIF($B$1:B1;$A$2:$A$100);0)))

Change the semi-colons to comma and use iferror instead of IF(ISERROR...

[ChemistB]

With Excel 2010, he can use Remove Duplicates (data tab) once he has moved all the names to column E

[Cutter]

@akalien

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.