Hijrofoyle
New Member
- Joined
- Oct 7, 2002
- Messages
- 35
when the MAX function returns a value from a column i.e. MAX(A1:A50) is there any way to determine what cell it's refering to? Where the cell with the max value is?
I'm using the max function and it keeps returning a max value of 3.440000000E+00 but that is not a value that occurs in any of my columns occuring to the find tool. Any help would be appreciated.
I'm using the max function and it keeps returning a max value of 3.440000000E+00 but that is not a value that occurs in any of my columns occuring to the find tool. Any help would be appreciated.