+ Reply to Thread
Results 1 to 2 of 2

Remove Dropdown List if Text in adjacent cell

  1. #1
    Forum Contributor
    Join Date
    03-03-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    365
    Posts
    136

    Remove Dropdown List if Text in adjacent cell

    I have a drop down list in all cells in column B and was wondering if it is possible to remove the list if the cell in the same row in column A has text in it. Not sure how to use an IF formula for this or if it can be done.

    Thanks for any help

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Remove Dropdown List if Text in adjacent cell

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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. [SOLVED] Search for the text in cell A1 in a list and remove the text if found in the list
    By kak0 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-24-2014, 11:01 PM
  2. Find text in a range on basis of dropdown selection & paste value adjacent cell
    By excel student in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 08:06 AM
  3. [SOLVED] Remove pattern from cells only if another cell has a specific selection from dropdown list
    By mook25 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-16-2013, 07:32 AM
  4. Populating numerical values in adjacent cell from using a dropdown list
    By up_and_under in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-30-2010, 10:30 AM
  5. Replies: 5
    Last Post: 03-12-2008, 05:01 PM

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