ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Lists in excel (https://www.excelbanter.com/new-users-excel/166046-lists-excel.html)

Kameca

Lists in excel
 
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

Lists in excel
 
Have a look he
http://www.contextures.on.ca/xlDataVal03.html

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

"Kameca" wrote in message
...
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

Lists in excel
 
see:

http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu200756


"Kameca" wrote:

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



All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com