Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Hey may I ask you something please?

[Closed]
Report
Posts
1
Registration date
Friday March 19, 2010
Status
Member
Last seen
October 13, 2014
 -
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
 -
i have two columns "County" and "County Code" i want to check country code not blank , and country code blank then return a value from a County to a new column
how can I do that please?

1 reply

Answer 1 / 1
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
 468
Hi Shivraj,

Let's say that "County" is column A and "County Code" is column B. Then we can use column C as the "new column".

Use the following formula in column C:
=IF(B2="",A2,"")

Best regards,
Trowa
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!