Multiple if condition help please

map6122

New Member
Joined
Jan 28, 2016
Messages
22
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]
 
OR

Thinking about doing it with formula still.
This would allow you to easily add mor companies into the list

Code:
=IF(COUNT(SEARCH({"C1","C2","C3"},A1)),A1,"OTHER")

dave
 
Upvote 0
Tetra201 it worked. Sorry for late reply. I was keep trying it until I found error on my side.

Thank you so much for your help
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top