Lists in excel

Thread view:

Thread rating:

Kameca - 14 Nov 2007 17:52 GMT

Is there a way to have a list that will eliminate a value once it is already
used in a group of cells?

Bernard Liengme - 14 Nov 2007 20:39 GMT

Have a look here:
http://www.contextures.on.ca/xlDataVal03.html

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Is there a way to have a list that will eliminate a value once it is
> already
> used in a group of cells?

Gary''s Student - 14 Nov 2007 20:43 GMT

see:

http://www.cpearson.com/excel/Duplicates.aspx

Signature

Gary''s Student - gsnu200756

> Is there a way to have a list that will eliminate a value once it is already
> used in a group of cells?