At 07:15 26/03/2013 -0700, Jason C. Wells wrote:
That works well. I'll check it against real data today. The
details of the numerical comparison are hidden from me with that equation ...
I'm sure you'll be able to analyse the formula =VLOOKUP(A1;C$1:D$9;2)
- but here goes.
The array C1 to
On 2013-03-27 20:47, Brian Barker wrote:
At 07:15 26/03/2013 -0700, Jason C. Wells wrote:
That works well. I'll check it against real data today. The details
of the numerical comparison are hidden from me with that equation ...
I'm sure you'll be able to analyse the formula
I too hadn't realized the value of the last parameter being 1 (meaning
it takes the next number below). I had trouble getting the formula to
work until I realized I had pasted the array from the email and some of
the numbers were formatted as text, others not, so I was getting almost
all
At 08:43 27/03/2013 -0400, Carl Paulsen wrote:
I too hadn't realized the value of the last parameter being 1
(meaning it takes the next number below). I had trouble getting the
formula to work until I realized I had pasted the array from the
email and some of the numbers were formatted as
On 03/25/13 21:48, Brian Barker wrote:
I trust this helps.
That works well. I'll check it against real data today. The details of
the numerical comparison are hidden from me with that equation but I'll
read up on it more now that I now I'm going in the right direction.
I must have had
Oops, sent this to the original sender, not the list:
Please clarify:
I haven't had any luck figuring out a method to compare each element
of a list of numbers to each element of a differently sized list of
numbers. What I want would bo something very much like VLOOKUP, but
instead of
I agree that the original question is a little confusing. What
everybody seems to have forgotten in their replies, though, is that if
the lookup list is sorted then a non-match will be treated as if it
matched the next lower value (for example, looking up 6 in a list of odd
numbers will
At 10:32 25/03/2013 -0700, Dave Liesse wrote:
I agree that the original question is a little confusing. What
everybody seems to have forgotten in their replies, though, ...
I don't think anyone has had the chance to forget anything: you have
yet to tell us exactly what you are trying to do.
OK. Take two. Since VLOOKUP for numbers with an inequality is not
meaningful, what I precisely hope to do is this. I hope that the
preformatted columns survive the mailer software.
Give the following columns:
A B C D
--- --- --- ---
1.1 eqn 3 0.10
At 21:17 25/03/2013 -0700, Jason C. Wells wrote:
OK. Take two. Since VLOOKUP for numbers with an
inequality is not meaningful, ...
It will do what you require, I think.
... what I precisely hope to do is this. I hope
that the preformatted columns survive the mailer software.
Give the
On 03/25/2013 12:15 AM, Jason C. Wells wrote:
I haven't had any luck figuring out a method to compare each element
of a list of numbers to each element of a differently sized list of
numbers. What I want would bo something very much like VLOOKUP, but
instead of matching strings, it would
At 21:15 24/03/2013 -0700, Jason C. Wells wrote:
I haven't had any luck figuring out a method to compare each element
of a list of numbers to each element of a differently sized list of
numbers. What I want would do something very much like VLOOKUP, but
instead of matching strings, it would
12 matches
Mail list logo
