Multiple if condition help please

[map6122]

Hello fellas,

I have over 60000 rows of data in excel 2010.
Each row have unique client name

like I have 4 client names I want to keep the same as their real name in Client placeholder to automate column. I have another 40 clients like John and David that I want to assign them Other in Client placeholder to automate column. Is there a way to do it??
Thanks in advance.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Client name [/TD]
[TD]Client Placeholder to automate[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]ABC[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC1[/TD]
[TD]ABC1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC2[/TD]
[TD]ABC2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Other[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]Other[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

Place this in your placeholder column and copy down:

=IF(OR(A1="ABC",A1="ABC1",A1="ABC2",A1="ABC3"),A1,"Other")

 

[map6122]

You are AMAZING Tetra201!! it worked

 

[FDibbins]

A shorter version of Tetra's....

=IF(left(A1,3)="ABC",A1,"Other")

 

[Tetra201]

@map6122:

Glad to have been of help.

 

[map6122]

quick question sorry I forgot to add that what if I want to count David as ABC client?

 

[Tetra201]

@FDibbins:

I thought about the shorter version, but then decided that "ABC" might not be the actual name.

 

[FDibbins]

@FDibbins:

I thought about the shorter version, but then decided that "ABC" might not be the actual name.

Good point, that is why it is always better to have sample data that closely approximates your real data.

@ map, can you provide some realist sample data?

 

[Tetra201]

quick question sorry I forgot to add that what if I want to count David as ABC client?

Does it mean you want to have "ABC" in the placeholder column for David? Or something else?

 

[FDibbins]

If there are many "keeps" names, then perhaps use MATCH to find them?