Recognizing Numbers or names as duplicates
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 |
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 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 |
All times are GMT +1. The time now is 06:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com