lookup to return larger value
It works. Very helpful. Thanks Grove!
"Harlan Grove" wrote:
Christobee wrote...
I get and Error message with both of your formulas for some reason the
formulas contain invalid data
....
Did you enter the *ARRAY* formulas as *ARRAY* formulas, meaning holding
down [Ctrl] and [Shift] keys before pressing [Enter]?
|