Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel help

  • 16-02-2015 09:45AM
    #1
    Lovely Bloke
    Closed Accounts Posts: 14,748 ✭✭✭✭


    Hey, hoping someone can help me.

    I have three columns, B, C, D, and about 40 rows of data.

    In each cell I have a drop down Y or N

    I want to restrict each cell in the row from displaying Y if another cell in the row already has a Y - they can all be N.


Comments

  • #2
    homer911
    Registered Users, Registered Users 2 Posts: 5,069 ✭✭✭homer911


    It looks like you would need a bit of VB code to have both Y/N picklists as well as validation of the total Ys set - attached is a version checking the number of Ys using the standard data validation option


  • #3
    homer911
    Registered Users, Registered Users 2 Posts: 5,069 ✭✭✭homer911


    I think this is what you want actually..

    http://www.contextures.com/xlDataVal03.html


Advertisement