Hi David,
I do this regularly by filling the column next to the data (assumed to
be in column 'A') with this formula:
=If(A1=A2;"";A1)
This results in a column of unique entries. I copy it, paste special /
data only, then sort.
tc
David Rudel wrote:
Hey guys, how can I use "Find and Replace" to find instances of two adjacent
cells having identical content?
In particular, I am trying to figure out how to use regular expression to
take a sorted list and delete identical entries:
So
A
A
A
B
C
CC
D
D
EEE
F
F
Would become
A
B
C
CC
D
EEE
F
Any help would be appreciated.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
