Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to write a macro that will find if I have entered a duplicate entry on
a worksheet. Any suggestions? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Never mind, found an answer from a previous post that has been very helpful:
"You may want to look at Chip Pearson's site. He has lots of techniques to work with duplicates: http://www.cpearson.com/excel/Duplicates.aspx" "Jesse" wrote: I want to write a macro that will find if I have entered a duplicate entry on a worksheet. Any suggestions? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Never mind, I found a website from a previous post that has been great to
track down duplicate entries: http://cpearson.com/excel/Duplicates.aspx "Jesse" wrote: I want to write a macro that will find if I have entered a duplicate entry on a worksheet. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to change the default in Excel from "find next" to "find all" | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Macro to find copy "header" and paste | Excel Discussion (Misc queries) |