Brad Rogers wrote:
On Sat, 09 Oct 2010 15:05:48 +0200
Andreas Säger wrote:
Hello Andreas,
For the given order of columns and _ascending ordered_ lookup vector
in B:
{snip}
Thanks for the tips, Andreas. I've actually achieved what I wanted
using vlookup, as per Mike Scott's advice.
Good to
On Sat, 9 Oct 2010 15:37:18 -0700
John Jason Jordan dijo:
>I only ever used Impress once several years ago. Now I need to use it
>again, but I am far from an expert.
>
>I placed a PNG graphic on a slide. There is also a text frame on the
>slide, and I want the text to wrap around the graphic.
>
>
I only ever used Impress once several years ago. Now I need to use it
again, but I am far from an expert.
I placed a PNG graphic on a slide. There is also a text frame on the
slide, and I want the text to wrap around the graphic.
I have scoured though the Help file and it appears to be "Adjust to
On Sat, 09 Oct 2010 15:05:48 +0200
Andreas Säger wrote:
Hello Andreas,
> For the given order of columns and _ascending ordered_ lookup vector
> in B:
{snip}
Thanks for the tips, Andreas. I've actually achieved what I wanted
using vlookup, as per Mike Scott's advice.
Good to see that there's m
On Sat, 09 Oct 2010 14:57:46 +0200
"Johnny Rosenberg" wrote:
Hello Johnny,
> Well, you could insert a new column and then hide it…
:-)
--
Regards _
/ ) "The blindingly obvious is
/ _)radnever immediately apparent"
Dream on white boy, dream on black girl
Or
Andreas Säger wrote:
If the scale is not in ascending order, the match point may not reflect
better subsequent matches.
Like your example:
=INDEX({"Cat";"Dog";"Mouse"};MATCH( 3 ;{2;4;3})) => "Cat"
which is obviously wrong, but the lookup stops at the 4.
Brad Rogers wrote:
Hello All,
I'm trying to get text printed in a cell in Calc based on the values
found in other cells, as follows;
Col1 Col2
Row1 Cat2
Row2 Dog4
Row3 Mouse 3
The text I want to output to the result cell is from Col1, based on the
values in Col2. Specifically,
Den 2010-10-08 20:44:00 skrev Brad Rogers :
On Fri, 08 Oct 2010 10:50:09 -0700
JOE Conner wrote:
Hello JOE,
You could have just hidden the column. FORMAT => COLUMN => HIDE.
You're right, but as the column was being used as a spacer anyway, I
opted for white on white.
Well, you could in