David Evans
Active Member
OK Ladies and Gents - I need to pick a value from the UDF column that reflects the highest value in Rate having selected only those rows with an amount gretaer than zero ....
I've been trying to get sumproduct to produce an answer to no avail .....
The correct answer is UDF7, being the corresponding max rate for all amounts over 0
All help gratefully accepted as usual
D
I've been trying to get sumproduct to produce an answer to no avail .....
The correct answer is UDF7, being the corresponding max rate for all amounts over 0
All help gratefully accepted as usual
D