Previous Topic Next Topic

Hey may I ask you something please?

Closed
shivraj Posts 1 Registration date Friday March 19, 2010 Status Member Last seen October 13, 2014 - Oct 13, 2014 at 02:48 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Oct 13, 2014 at 11:42 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Oct 13, 2014 at 11:42 AM
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