I
IGM
Hi:
I have
abc 0
abc 10
abc 20
abc 30
efg 0
efg 10
abc -20
efg 50
How can I express a formula to obtain -20 for "abc"
and 50 for "efg" out of this data?
My goal is to get the numeric value (B) corresponding to the highest
matching row within the specified range.
Thanks,
IGM
I have
abc 0
abc 10
abc 20
abc 30
efg 0
efg 10
abc -20
efg 50
How can I express a formula to obtain -20 for "abc"
and 50 for "efg" out of this data?
My goal is to get the numeric value (B) corresponding to the highest
matching row within the specified range.
Thanks,
IGM