you may also use OTHER ways,

your 10 names in A1:J1

=+IF(SUM((A2=$A$1:$J$1)*{1}),A2,"ALL OTHERS")
hit ctrl-shift-ent..

or =+IF(MAX((A2=$A$1:$J$1)*{1}),A2,"ALL OTHERS")
hit ctrl-shift-ent..
--
*****
birds of the same feather flock together..



"Ron Coderre" wrote:

Try something like this:

With
Your list of all names in Col_A, beginning in A2
and
N1:N10 contains the list of names you want to "keep"

Try this in Col_B:
B2: =IF(COUNTIF($N$1:$N$10,A2),A2,"All Other")
Copy that formula down as far as you need

Then....just
select the Col_B formula cells
[Ctrl]+C......that's the shortcut for <edit<copy
<edit<paste special<values

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Angie" wrote:

I have a list of names, 10 of which I want to keep as is and the others I
want to change to "all other" (there are too many to use find & replace).
Can I create a new column and new variable to do this?

Thanks,