| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No repeats of name in same colum
Excel 2003 can i make a colum were a name can not be repeated in taht colum
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No repeats of name in same colum
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No repeats of name in same colum
Hi,
Select your range which in my case is A1 - A40 and then Data|Validation|Custom enter the formula =COUNTIF($A$1:$A$40,A1)=1 Mike "Headworth" wrote: Excel 2003 can i make a colum were a name can not be repeated in taht colum |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colum 1 = product #'s than colum 2 = prod. disc. | Excel Discussion (Misc queries) | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
| lookup in colum a and compare values in colum b | Excel Worksheet Functions | |||
Hybrid Mode
