If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel help

Lovely Bloke · 2015-02-16 09:45:06

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.

16-02-2015 10:45am

#1

Lovely Bloke

Closed Accounts Posts: 14,748 ✭✭✭✭

Join Date: November 2012

Posts: 13936

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.

0

Comments

#2 16-02-2015 3:14pm

homer911

Registered Users, Registered Users 2 Posts: 5,135 ✭✭✭

Join Date: September 2007

Posts: 4742

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

0
#3 16-02-2015 3:24pm

homer911

Registered Users, Registered Users 2 Posts: 5,135 ✭✭✭

Join Date: September 2007

Posts: 4742

I think this is what you want actually..

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

0