Grantx
11-14-2007, 03:08 PM
Please refer to attachment.
I have tried numerous suggestions from various web sites buy none work. Maybe someone here could make a sugestion.
Column A contains ever changing random values (hence, cannot be sorted). Column B values are fixed.
I need to determine the maximum value in A1:A10 and return its corresponding value from B1:B10. The figures have to stay in their respective columns (hence no vlookup).
Any suggestions greatly appreciated.
Grant.
I have tried numerous suggestions from various web sites buy none work. Maybe someone here could make a sugestion.
Column A contains ever changing random values (hence, cannot be sorted). Column B values are fixed.
I need to determine the maximum value in A1:A10 and return its corresponding value from B1:B10. The figures have to stay in their respective columns (hence no vlookup).
Any suggestions greatly appreciated.
Grant.