Re: [users] (Calc) Text output for cell based on other cell values

2010-10-09 Thread Brad Rogers
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

Re: [users] (Calc) Text output for cell based on other cell values

2010-10-09 Thread Johnny Rosenberg
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

Re: [users] (Calc) Text output for cell based on other cell values

2010-10-08 Thread 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. -- Regards _ / ) "The blindingly obvious is

Re: [users] (Calc) Text output for cell based on other cell values

2010-10-08 Thread JOE Conner
On 10/8/2010 9:10 AM, Brad Rogers wrote: On Fri, 08 Oct 2010 15:58:57 +0100 Mike Scott wrote: Hello Mike, Is vlookup() of any help? It seems in the right sort of direction It is indeed; I don't seem to be able to get that function to do a lookup right to left, rather than left to right, bu

Re: [users] (Calc) Text output for cell based on other cell values

2010-10-08 Thread Brad Rogers
On Fri, 08 Oct 2010 15:58:57 +0100 Mike Scott wrote: Hello Mike, > Is vlookup() of any help? It seems in the right sort of direction It is indeed; I don't seem to be able to get that function to do a lookup right to left, rather than left to right, but I've overcome that by duplicating the num

Re: [users] (Calc) Text output for cell based on other cell values

2010-10-08 Thread Mike Scott
On 08/10/10 15:00, 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 C

[users] (Calc) Text output for cell based on other cell values

2010-10-08 Thread Brad Rogers
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, the lowest value. SO