[users] Re: Calc: Sort double columns

2011-10-03 Thread Tom Keene
On Oct 3, 2011, at 6:40 AM, Dotan Cohen wrote: I am reviewing the records of a local shop to help him convert to Open Office. I have found no problems with the simple Word documents that he uses, but he is using MS Excel where he should have a real database. We all know about efforts to

[users] Re: Help with writing macro

2011-09-21 Thread Tom Keene
How about passing your data in an array. Then you only need one parameter. On Sep 21, 2011, at 12:53 PM, Grzegorz Sójka wrote: On 09/21/11 18:53, Johnny Rosenberg wrote: I haven't done this myself, but I would try to use ”Optional” and ”IsMissing”, something like this: Function

[users] Re: how to de-duplicate.

2011-09-06 Thread Tom Keene
In Calc select DataFilterAdvanced Filter... Then expand the More drop down menu. Click the No duplication checkbox. You will get a single instance of every entry in your original column. Tom K On Sep 5, 2011, at 5:39 PM, Bob Marcus wrote: I’m relatively new to ooS, but I am not finding a