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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 9: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 2:14pm

homer911

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

Join Date: September 2007

Posts: 4756

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 2:24pm

homer911

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

Join Date: September 2007

Posts: 4756

I think this is what you want actually..

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

0