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 Cat 2 Row2 Dog 4 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, in this instance, I'd like "Cat" as the o/p. Finding the MIN value is easy but after that, I'm stuck. I've tried googling, but don't seem able to invoke the right incantations. Any help will be appreciated, thanks. -- Regards _ / ) "The blindingly obvious is / _)rad never immediately apparent" That's what I call you Heaven Sent - INXS
signature.asc
Description: PGP signature