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? -- Harold Fuchs London, England Please reply *only* to [email protected]
