2009/5/30 Brian Barker :
> At 10:49 29/05/2009 -0700, Mark Knecht wrote:
>>
>> Turns out I am still a bit confused about the VLOOKUP function. It works,
>> exactly like you suggest it should in this application, but reading the help
>> file I have the impression that since we didn't set the SortOrd
At 10:49 29/05/2009 -0700, Mark Knecht wrote:
Turns out I am still a bit confused about the VLOOKUP function. It
works, exactly like you suggest it should in this application, but
reading the help file I have the impression that since we didn't set
the SortOrder variable, telling calc that the
If you press Ctrl+F2 you can make cell formulas by clicking and typing
and with some guidance. If you look up the VLOOKUP command, double
click it and place the cursor in the Sort Order field, you can see
information about that parameter. It says that if it's TRUE or NOT
GIVEN, that means that the
On Thu, May 28, 2009 at 3:56 PM, Mark Knecht wrote:
> On Thu, May 28, 2009 at 3:15 PM, Brian Barker
> wrote:
>> At 14:10 28/05/2009 -0700, Mark Knecht wrote:
>>>
>>> I have a large table of weekly equity data coming out of another program
>>> from which I need to collect a compacted table of the
On Thu, May 28, 2009 at 3:15 PM, Brian Barker wrote:
> At 14:10 28/05/2009 -0700, Mark Knecht wrote:
>>
>> I have a large table of weekly equity data coming out of another program
>> from which I need to collect a compacted table of the week by week results.
>> The table is currently about 10 year
At 14:10 28/05/2009 -0700, Mark Knecht wrote:
I have a large table of weekly equity data coming out of another
program from which I need to collect a compacted table of the week
by week results. The table is currently about 10 years of data with
(typically) 5-10 lines/week. The input data to ca
I have a large table of weekly equity data coming out of another
program from which I need to collect a compacted table of the week by
week results. The table is currently about 10 years of data with
(typically) 5-10 lines/week. The input data to calc looks like the
following data, somewhat simplif