Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How-to Prevent Value Duplication
I have 32 events that need to be ranked in order of preference.
How can I format 32 cells (all contained in a single column) so that each number 1-32 can only be used once, thereby ranking the events from 1 to 32? Also, I was hoping to put a frozen row at the top of the sheet listing which numbers from 1-32 are still available, meaning they have not yet been input in one of the 32 cells. How could I accomplish this? Thanks for the help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How-to Prevent Value Duplication
See http://www.contextures.com/xlDataVal03.html
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "StrapJr" wrote in message ... I have 32 events that need to be ranked in order of preference. How can I format 32 cells (all contained in a single column) so that each number 1-32 can only be used once, thereby ranking the events from 1 to 32? Also, I was hoping to put a frozen row at the top of the sheet listing which numbers from 1-32 are still available, meaning they have not yet been input in one of the 32 cells. How could I accomplish this? Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Prevent Duplicate Data from inputing using input application? | Excel Worksheet Functions | |||
How to Prevent Duplicate Data from inputing using input application? | Excel Discussion (Misc queries) | |||
How to Prevent Duplicate Data from inputing using input application? | New Users to Excel | |||
How do I prevent duplication of numbers in a column | Excel Discussion (Misc queries) | |||
prevent duplication | Excel Discussion (Misc queries) |