Hi all

Does anyone know if there's a way for excel to tell me which cell has returned the max from a range, for example if i ask excel to find a max "=max(B10:B34)" then it will display the result 0.15 for example. Is there a way to make excel tell me which cell it found this data in, for example if the max first appears in B22 i would like it to display this in a new column

any help greatly appreciated

Thanks in advance
Owen