Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do I have to enter info in all cells in order to find duplications
I have a workbook in which I have been entering a "dummy" line so I am able
to see if there is any duplications is there a better way about going about this instead of wasting my time with this "dummy" line?? Do I have to enter info at all? Can i delete or add lines without messing up my formatting and drop downs? Any help would be appreciated.. Stephanie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do I have to enter info in all cells in order to find duplications
We can't see your formatting or the placement of dropdowns so hard to say if
deleting duplicates would "mess up" what you have. Do you just want to prevent duplicates or find the ones you may have and delete all but one of them? See Chip Pearson's site for preventing or flagging duplicates. http://www.cpearson.com/excel/NoDupEntry.aspx http://www.cpearson.com/excel/Duplicates.aspx Gord Dibben MS Excel MVP On Tue, 13 May 2008 13:04:00 -0700, StephanieIacono wrote: I have a workbook in which I have been entering a "dummy" line so I am able to see if there is any duplications is there a better way about going about this instead of wasting my time with this "dummy" line?? Do I have to enter info at all? Can i delete or add lines without messing up my formatting and drop downs? Any help would be appreciated.. Stephanie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
F2 edit cells - new info disappears when I hit enter | Excel Discussion (Misc queries) | |||
can i prevent duplications in cells | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) |