I can always use R, but sometimes Gnumeric comes in handy to whittle down lists filled with duplicates in a jiffy.
Simplified steps from
1. Say you have a column A with A1 to A100 rows with duplicate data that you want to eliminate
2. Go to Data > Advanced Filter. Under the input tab, choose list range as A1 to A100.
3. I don't understand why Gnumeric needs a criteria range for everything but it does... Even for duplicate-value-finding that involves no mathematical formulas. So choose a criteria range. Say B1 to B2. Make sure that the first cell of the criteria range has the same column header as the list range. So if, say your cell A1 was named "Numbers" then B1 should also be "Numbers". Leave B2 blank.
4. Check unique records only
5. Go to the Output tab. Choose an output range (longer than the input range, just to prevent any complaints from gnumeric). Click OK.
You should have the original list with no duplicates in the output range.
That's camelcamelcamel.com at this :::link::: It's incredibly handy for keeping a watch on things.
(e:paul) just checked this on his phone and the price had dropped back to what it was earlier ($86.66). I deleted the wok from cart as soon as I saw the hideous price change. I am sure others must have as well. All this price see-sawing is so ludicrous.
what are you using to track prices