Results 1 to 3 of 3

Thread: Have a Yes/No show up based on table data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Have a Yes/No show up based on table data

    Morning all!

    Was working on an excel spreadsheet and could use your help please!

    Based on the table below, is there a function I could use to populate another cell with either "Yes" or "No" depending on the table's data?

    More specifically I have two separate sheets that are populated with data based on their Session (bolded below). I would like to be able to populate a cell on those sheets with Yes or No if there is at least one row/user that has a Yes in the Code column (Based on specific Session # too). If it's blank, I'd like it to place No instead.

    Is that possible? I tried using something based on index and match but that only worked on the top most row of the session.

    Thanks!
    Kevin




    First Name: Last Name: E-mail: Phone: Session Contact Status: Primary Confirmed Alternate Confirmed Profile: Team Code
    NAME NAME 123@yahoo.com (123)456-7899 1 Qualified 1 X Yes
    NAME NAME 456@yahoo.com (123)456-7899 1 Qualified 1 X
    NAME NAME 123@yahoo.com (123)456-7899 2 Qualified 1 X
    NAME NAME 123@yahoo.com (123)456-7899 2 Qualified 1 X Yes
    Last edited by SpeedyKevin; Aug 1st, 2019 at 11:56 AM.

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    167
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Have a Yes/No show up based on table data

    I feel like you need a macro.

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,303
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Have a Yes/No show up based on table data

    But which column do you want to fill?
    Are the 2 sheets related?
    In your example, what is the expected result, 4 Yes in the "Code" column, or 4 yes in another column?
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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