Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Mon, 12 Apr 2010 23:18:48 -0400, Ron Rosenfeld
wrote: There is a potential problem with Max's solution if one suburb name is a part of a subsequent suburb name, or if a suburb name happens to also be a street name. The problem arises because Max's algorithm does not check that the position of the match is at the end of the string. Of course, even with this solution, one could still have suburb name combinations that would return unwanted results, if the repeated word were at the end of the suburb name, and occurred first in order. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
removing duplicate entries in multiple worksheets | Excel Worksheet Functions | |||
Removing duplicate rows | New Users to Excel | |||
Removing duplicate entries | New Users to Excel | |||
How to remove duplicate events in column | New Users to Excel | |||
removing duplicate rows | Excel Discussion (Misc queries) |