ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to exclude data already used? (https://www.excelbanter.com/new-users-excel/77587-how-exclude-data-already-used.html)

Bill

How to exclude data already used?
 
I am new with this program (excel2003). I like to play logic games and have a
big question. If I have a group of values (letters, names or numbers) and I
want to use them on a new row/column without using the same value twice, How
do I deduct, or exclude that value from being used again? Thanks you much

Max

How to exclude data already used?
 
One thought .. Try Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal03.html
Data Validation -- Hide Previously Used Items in Dropdown
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bill" wrote in message
...
I am new with this program (excel2003). I like to play logic games and

have a
big question. If I have a group of values (letters, names or numbers) and

I
want to use them on a new row/column without using the same value twice,

How
do I deduct, or exclude that value from being used again? Thanks you much





All times are GMT +1. The time now is 01:17 AM.

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