ExcelBanter - No repeats of name in same colum

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - No repeats of name in same colum (https://www.excelbanter.com/excel-discussion-misc-queries/192180-no-repeats-name-same-colum.html)

Headworth

No repeats of name in same colum

Excel 2003 can i make a colum were a name can not be repeated in taht colum

Gary''s Student

No repeats of name in same colum

See:

http://www.cpearson.com/excel/NoDupEntry.aspx
--
Gary''s Student - gsnu200793

Mike H

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

All times are GMT +1. The time now is 08:48 PM.