Leaderboard

A regular expression to provide unique hrefs is certainly possible. One way would be to use a negative lookahead. But compared to using _ArrayUnique(), it would be MUCH slower and inefficient due to all of the backtracking that would need to be done by the regular expression engine. _ArrayUnique() uses a scripting dictionary to remove duplicates which is lightning fast compared to most other AutoIt methods, assuming you area dealing with a 1D or 2D array and only need to remove duplicates based on a single column. Why do you want to avoid using _ArrayUnique()?

A new version a bit simplified and corrected. see first post.

It's a very usual problem, reason why when a user asks for help about regex the first answer is at 99% usually : please define precisely the requirements and the expected result(s) Great. But please keep in mind that - the results to grab must be enclosed by parenthesis - in my snippet $skeyword2 MUST be preceded by "=" and followed by "|" and the number to get. If ANY additional requirement is added then the pattern must be modified

@robertocm It works if you use the correct parameters: $oRange.RemoveDuplicates(2, $xlYes) Or Global $aDupCols = [2] $oRange.RemoveDuplicates($aDupCols, $xlYes) Range.RemoveDuplicates

@hemal Please go back and reread my last response, particularly the first portion of the last bullet point.