restaurant table booking list

  • Thread starter Thread starter chris-noelbaker
  • Start date Start date
C

chris-noelbaker

My knowledge of excel is in it's infancy and I have come upon
stumbling block.

I have created a booking list for a restaurant. I have a colum
containing 15 cells each with a dropdown list containing numbers 1 -15
I want to be able to slect a number in 1 of the cells but if it i
already in use in another cell then the value should not be allowed.
The cells will be used to select a table number of 1 to 15. I trie
using an IF statement but i could only cover 8 of the numbers because
was limited to eight IF statements in a cell.

Please Hel

+----------------------------------------------------------------
| Attachment filename: book1.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=377070
+----------------------------------------------------------------
 
I believe this is the formula you need:
=IF(COUNTIF($A$2:$A$10,B2)=1,"",B2)
I know this may not mean much to you, and I do not have time to answer
further. I believe you will find what you want at www.contextures.com


--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
chris-noelbaker said:
My knowledge of excel is in it's infancy and I have come upon a
stumbling block.

I have created a booking list for a restaurant. I have a column
containing 15 cells each with a dropdown list containing numbers 1 -15.
I want to be able to slect a number in 1 of the cells but if it is
already in use in another cell then the value should not be allowed.
The cells will be used to select a table number of 1 to 15. I tried
using an IF statement but i could only cover 8 of the numbers because I
was limited to eight IF statements in a cell.

Please Help


+----------------------------------------------------------------+
| Attachment filename: book1.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=377070|
+----------------------------------------------------------------+

------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Here's 1 way to do this;

in E2, enter the formula:
=+IF(COUNTIF($C$2:$C$16,A2)=0,A2,"")

Copy this formula down from E2 to E16.

Now select the range C2:C16, and go to Data>Validation

erase the information from SOURCE (currently pointing to A2:A16), and
replace with E2:E16.





chris-noelbaker said:
My knowledge of excel is in it's infancy and I have come upon a
stumbling block.

I have created a booking list for a restaurant. I have a column
containing 15 cells each with a dropdown list containing numbers 1 -15.
I want to be able to slect a number in 1 of the cells but if it is
already in use in another cell then the value should not be allowed.
The cells will be used to select a table number of 1 to 15. I tried
using an IF statement but i could only cover 8 of the numbers because I
was limited to eight IF statements in a cell.

Please Help


+----------------------------------------------------------------+
| Attachment filename: book1.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=377070|
+----------------------------------------------------------------+

------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top