Looking for a Macro code to update corresponding columns

Question

I have a column which has single and multiple languages such as "English", "French", "Russian", "English or Dutch", "French & English".

My query is I would like to write macro code where if we have single language (English) then it should be updated as "Single" and "Multiple" for multiple language ("English or French" , "English & French"). I tried recording a macro but no luck as we keep on getting new languages on a regular basis.

This can be done with formulas, if you don't have any languages like Western Punjabi or something you can just look for spaces and if it exists then it is multiple. — Warcupine, May 10 '22 at 13:02

score 0 · Answer 1 · answered May 10 '22 at 13:25

0

You can try this formula:

=IF(AND(ISERROR(FIND("&", B1) > 0), ISERROR(FIND("OR", B1) > 0)), "Single", "Multiple")

answered May 10 '22 at 13:25

Bhagyesh Jain

323
2
10

Looking for a Macro code to update corresponding columns

1 Answers1