SpeedyKevin
New Member
- Joined
- Apr 26, 2019
- Messages
- 17
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
<tbody>
</tbody>
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 | ||
<tbody>
</tbody>
Last edited: