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.
(e:Paul) - not only did Erin say it was the next step, she demonstrated the Eka Pada Urdhva Dhanurasana (the one-legged upward/inverted bow). Those must be some really high-powered specs! I thought I was the blind one because I intentionally don't wear specs.
I am pretty relieved that you are not my yoga teacher, (e:metalpeter)! Last time you were insisting that do all the inversions with tea cups balanced.
LOL, but you are right though. I am not sure I could do it all the time. Maybe yesterday was a fluke... I am going to try and reach the next stage but can't tell when that will be. And (e:Paul) is always messing up gymnastics with yoga. He doesn't see the fine line... ;-)
Now related to that (e:tinypliny) now that you have that down... The next part is to get it mastered so you can all ways do it... Not not sure if they do this in Yoga... But I think the next step would be to start moving your hands in closer to your feet (acrobatics maybe.......Once they are in (from what I have seen) close enough both feet can come off the floor?
Isn't a back hand spring Gymnasitics?
(I went Monday... maybe tonight?)
Dammit... yoga was calling me last night and I shoulda just listened. Congrats on the wheel!
(e:Terry) says she said it. I must have not noticed because I didn't have my glasses on.
Oh I can totally do that. I wish she had said that was the next step.
The next step after that is back handspring!