Recognizing Numbers or names as duplicates

Gord Dibben · 09-06-2005, 03:05 AM

Prevention of duplicates......

See Chip Pearson's site

http://www.cpearson.com/excel/NoDupEntry.htm

At bottom of that page see links to other functions like highlighting
duplicates, deleting duplicates and others.

Gord Dibben Excel MVP

On Mon, 8 Aug 2005 10:59:02 -0700, texansgal
<[email protected]> wrote:

>I am wondering if there is any way to program Excel to be able to prevent
>duplicating a number or a name. I can't have it sorted by either of these, I
>must have it sorted by date...
>
>Thanks,
>Vanessa

Gord Dibben · 09-06-2005, 10:05 AM

Prevention of duplicates......

See Chip Pearson's site

http://www.cpearson.com/excel/NoDupEntry.htm

At bottom of that page see links to other functions like highlighting
duplicates, deleting duplicates and others.

Gord Dibben Excel MVP

On Mon, 8 Aug 2005 10:59:02 -0700, texansgal
<[email protected]> wrote:

>I am wondering if there is any way to program Excel to be able to prevent
>duplicating a number or a name. I can't have it sorted by either of these, I
>must have it sorted by date...
>
>Thanks,
>Vanessa

Gord Dibben · 09-06-2005, 12:05 PM

Prevention of duplicates......

See Chip Pearson's site

http://www.cpearson.com/excel/NoDupEntry.htm

At bottom of that page see links to other functions like highlighting
duplicates, deleting duplicates and others.

Gord Dibben Excel MVP

On Mon, 8 Aug 2005 10:59:02 -0700, texansgal
<[email protected]> wrote:

>I am wondering if there is any way to program Excel to be able to prevent
>duplicating a number or a name. I can't have it sorted by either of these, I
>must have it sorted by date...
>
>Thanks,
>Vanessa

Gord Dibben · 09-06-2005, 03:05 PM

Prevention of duplicates......

See Chip Pearson's site

http://www.cpearson.com/excel/NoDupEntry.htm

At bottom of that page see links to other functions like highlighting
duplicates, deleting duplicates and others.

Gord Dibben Excel MVP

On Mon, 8 Aug 2005 10:59:02 -0700, texansgal
<[email protected]> wrote:

>I am wondering if there is any way to program Excel to be able to prevent
>duplicating a number or a name. I can't have it sorted by either of these, I
>must have it sorted by date...
>
>Thanks,
>Vanessa

Gord Dibben · 09-06-2005, 06:05 PM

Prevention of duplicates......

See Chip Pearson's site

http://www.cpearson.com/excel/NoDupEntry.htm

At bottom of that page see links to other functions like highlighting
duplicates, deleting duplicates and others.

Gord Dibben Excel MVP

On Mon, 8 Aug 2005 10:59:02 -0700, texansgal
<[email protected]> wrote:

>I am wondering if there is any way to program Excel to be able to prevent
>duplicating a number or a name. I can't have it sorted by either of these, I
>must have it sorted by date...
>
>Thanks,
>Vanessa

texansgal · 09-06-2005, 07:05 PM

I am wondering if there is any way to program Excel to be able to prevent
duplicating a number or a name. I can't have it sorted by either of these, I
must have it sorted by date...

Thanks,
Vanessa

Gord Dibben · 09-06-2005, 07:05 PM

Prevention of duplicates......

See Chip Pearson's site

http://www.cpearson.com/excel/NoDupEntry.htm

At bottom of that page see links to other functions like highlighting
duplicates, deleting duplicates and others.

Gord Dibben Excel MVP

On Mon, 8 Aug 2005 10:59:02 -0700, texansgal
<[email protected]> wrote:

>I am wondering if there is any way to program Excel to be able to prevent
>duplicating a number or a name. I can't have it sorted by either of these, I
>must have it sorted by date...
>
>Thanks,
>Vanessa