enter two different values from the same Data validation list

Annise Ventura 0 Reputation points
2024-01-29T15:55:26.1566667+00:00

I need to be able to plug in two different names in one cell from a set data validation list. We use excel to layout where employees will be working every day in our clinic. I need to be able to assign at least two clinical staff per doctor but i cannot split the cell without creating a new column. I just need to be able to plug in two clinic staff members name in the same cell within one column.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,305 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 20,266 Reputation points Microsoft Vendor
    2024-01-30T02:45:03.6233333+00:00

    Hi,

    I suggest you check if this method will help you:

    https://communityhub.sage.com/site_help/b/excel-tips-tricks-list/posts/multi-column-data-validation

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments