PDA

View Full Version : help please



محتاج2010
06-25-2011, 11:16 AM
How do I prevent two names or more, from participate in the value of the column (B)

mbarron
06-25-2011, 08:05 PM
You can use Data Validation to do this. I've altered your workbook to demonstrate. Change one of the values in your B values to one that is currently in the column to see the results of the validation.

Select one of the cells in the B column within your table and go to the Data tab. Choose the Data Validation drop down and the Data Validation... option to see the formula I used.

محتاج2010
06-25-2011, 10:58 PM
Thank you. But I want something else, please see the file

mbarron
06-26-2011, 08:38 AM
You are going to have to better explain what you want. The solution I provided keeps the same entery from being entered twice in the B column.

محتاج2010
06-26-2011, 09:39 AM
Thank you, and I hope that you see the last file