I am assigning numbers to file folders in excel; I need to know what to do so excel will warn me if I am duplicating a number.How can I do to stop in excel duplicate numbers?
To prevent duplicates you need to use data validation
first select cells
next go to data menu and data validation
choose allow: custom
you need the countif to be less than 1
use this formula:
=COUNTIF(start cell:end cell,cell)%26lt;=1
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment