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
2009/5/30 Brian Barker b.m.bar...@btinternet.com:
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
On Thu, May 28, 2009 at 3:56 PM, Mark Knecht markkne...@gmail.com wrote:
On Thu, May 28, 2009 at 3:15 PM, Brian Barker b.m.bar...@btinternet.com
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
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
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
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
On Thu, May 28, 2009 at 3:15 PM, Brian Barker b.m.bar...@btinternet.com 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
