Quote Originally Posted by Rick Rothstein View Post
... Does this modification do what you want?
Ok, I don't know if I'm doing anything wrong, but I set up the function and when I have it read =Largest(D$1, P$1) it does give me the highest value in Column Q but if I change the value in D$1, I'm getting the #VALUE error. I can't tell if it's working ...

I also don't get any values below where I insert the function if I copy it below the first instance. I get the #VALUE error again.

Would you like me to set up and upload a dummy data sheet?...

And, I don't know anything about the functions, but, to make it even more 'portable', I know you have the function default to two contiguous columns, but also be able to have it look something ike this: ?


=Largest(F$2, C$3, G$3)

Meaning:

1. Compare the value in Cell F$2 with all the values in Column C, then for all the values in Column C that are below the value in F$2, go to the same row in Column G, compare those values and give me the highest, etc...?

Where I could designate those columns? Just wondering... I gotta learn how to program! Thanks!