On 2002-04-19 11:50, kimbo wrote:
I have a column of numbers sorted in ascending order. How can I quickly identify those that are identical?
On 2002-04-19 15:25, Mark W. wrote:
Yogi, here are the differences between our approaches...
{"Data","Yours ","Mine"
;1,"",1
;1,1,1
;1,1,1
;2,"",""
;3,"",3
;3,3,3
;4,"",""
;5,"",5
;5,5,5}
...your's only "flags" the last duplicate row because A2=A1 only "looks backward" whereas OR(A2=A3,A2=A1) "looks" both "backward and forward".
This message was edited by Mark W. on 2002-04-19 15:28