+ Reply to Thread
Results 1 to 3 of 3

Replicate answers for the same groups using Drop Down List.

  1. #1
    Registered User
    Join Date
    09-23-2018
    Location
    USA
    MS-Off Ver
    2017
    Posts
    26

    Replicate answers for the same groups using Drop Down List.

    Hello there,

    I've been trying to solve this for a couple days but got to nowhere. So the problem is let's say I have 2 columns, one named Group and one is Response
    Group Response(Yes/No)
    A
    A
    B
    B
    C
    C

    My goal is to create a drop list with Yes/No option for the Response columns for every row, and if I choose Yes for the first row of Group A, the second row of Group A also turn YES. Also, if I choose Yes for the second row of Group A, the first row of Group will become Yes, same ideas with Group B and C, and I have more than 1k different groups. Basically, I want to have same answers (Yes or No) within the same group, and doesn't matter which one we click first for the drop down list.

    I tried to create a new sheet and used Vlookup, it worked well to return all answers as groups but it doesn't meet the requirement. They want to show the drop list on each row of the Response Column and make changes from there.

    Sorry I didn't know a better way to describe this problem. I hope to get help from you all. Thank you so much!
    Attached Images Attached Images

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Replicate answers for the same groups using Drop Down List.

    The best way would be to use VBA for that
    Right click on your Sheet1 tab, select Display Code
    and paste such code:

    Please Login or Register  to view this content.
    then save your file with macro-enabled extension - so xlsm or xlsb (or old xls)
    Best Regards,

    Kaper

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Replicate answers for the same groups using Drop Down List.

    Just to explain, you cannot have a formula AND a DD in the same cell, 1 would replace the other.

    there is nothing magical about a drop down (Data Validation). It is exactly the same as if you had typed the entry in manually, the only differences being that a DD can save you some typing, help avoid typos and help restrict entry to only a specified "list". Other than that, there is basically no difference. You would refer to it in formulas etc the exact same way as if you were referencing a manually entered cell.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Return multiple answers from a single drop-down list
    By Excelski in forum Excel General
    Replies: 5
    Last Post: 12-28-2017, 07:36 AM
  2. Replies: 3
    Last Post: 06-14-2016, 12:43 PM
  3. Replies: 9
    Last Post: 04-02-2015, 02:58 PM
  4. [SOLVED] How to create groups in pivot table drop down list
    By garciae2 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2013, 10:42 AM
  5. Filling individual answers in their groups
    By zuwanda in forum Excel General
    Replies: 3
    Last Post: 02-08-2012, 11:56 PM
  6. replicate regions drop down list
    By jerroldn in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-15-2011, 09:20 AM
  7. Replies: 3
    Last Post: 02-19-2009, 02:29 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