This equation will identify duplicates if and only if they are on
consecutive rows.
Harold Fuchs wrote:
On 21/09/2007, Paul <[EMAIL PROTECTED]> wrote:
<snip>
Harold, for some reason I could not get the sheet to sort properly after
applying your formula, even making sure the sort column was formatted as
integer.
After you enter the formula, you would need to copy the column, then paste
special (only paste back the values) , since if the formula remains it
will
report new values each time it is sorted. I have used the suggested method
many times and it seems to work.
Yes, sorry. I omitted the copy/paste special step. Apologies. Also, instead
of using a magic value it's simpler if the formula is
=IF(A2=A1);"Duplicate";"Unique") Now the generated values will either be
"Duplicate" or "Unique" and after the copy/paste-special and sort all the
"Uniques" will follow all the "Duplicates". No magic values required so no
knowledge of the data is necessary :-)
[snip]
I agree that the proposed solution of using autofilter is an excellent
idea
that I'll use myself from now on.
Hmm. I find this weird. I'm using OO 2.2.1 on Win XP SP/2. I open a new Calc
sheet and, in column A, I enter the values 1, 2, 1 in rows 1, 2, 3. Then I
do Data>Filter>Standard Filter>More, check the "No Duplication" box and
click OK. **All** the values disappear. This is true even if I sort the data
first. The same happens if I use row 1 as a heading and put the data in rows
2, 3 and 4. The heading stays but *all* the values disappear.
What am I missing, please?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
