+ Reply to Thread
Results 1 to 3 of 3

How2: IF column a = blank and column b = y, THEN make column a = X and column b = blank

  1. #1
    Registered User
    Join Date
    10-03-2018
    Location
    Madison, WI
    MS-Off Ver
    365
    Posts
    1

    Question How2: IF column a = blank and column b = y, THEN make column a = X and column b = blank

    Using PC and Office 365

    In Excel, how do I write the formula for IF column a = blank and column b = y, THEN make column a = X and column b = blank?

    Scenario - I have 2 columns, A and B
    When Column A = Blank and Column B = No author listed, I want to make Column A = X and Column B = Blank.

    How do I do this?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,482

    Re: How2: IF column a = blank and column b = y, THEN make column a = X and column b = blan

    Welcome to the forum!

    Not using formulae and functions, I am afraid - you will need VBA. Would you like me to move the thread for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,816

    Re: How2: IF column a = blank and column b = y, THEN make column a = X and column b = blan

    When you say "no author listed", do you mean that the cell contains that text, or that it is empty.

    You could do it manually by applying auto filters:

    Select < blanks > from the filter drop-down on A, then select < No author listed > or < blanks > for column B
    Then put an "X" in the first visible cell of column A and delete the contents of the corresponding cell in column B
    Then select those two cells and copy then down the remaining visible cells.
    Remove the filtering on those two columns.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 16
    Last Post: 07-10-2018, 06:38 PM
  2. [SOLVED] Need to make Sum Column blank if all cells being added are blank
    By JediDA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2018, 10:23 PM
  3. Replies: 0
    Last Post: 10-29-2015, 04:15 PM
  4. [SOLVED] need formula to this logic, A column number B column blank then C column desired name
    By vengatvj in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-02-2013, 10:30 PM
  5. Replies: 1
    Last Post: 06-01-2013, 01:27 AM
  6. Replies: 2
    Last Post: 10-04-2012, 03:19 PM
  7. Replies: 4
    Last Post: 05-10-2012, 08:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1