I'm using the following with great success!
=IF(MAX(RC[57]:RC[59])=(RC[58]),(RC[58]),IF(Max(RC[57]:RC[59])=(RC[59]),-(RC[59]),))
but
=IF(MAX(RC[59]:RC[63])=(RC[60]:RC[61]),(RC[60]:RC[61]),IF(MAX(RC[59]:RC[63])=(RC[62]:RC[63]),-(RC[62]:RC[63]),))
aparently it won't work because it refers to a range of cells. I've tried various methods of working around it, but have hit a wall - can anyone suggest a solution for the above code or some VB code that will do the same job?
Many thanks
Hugh
=IF(MAX(RC[57]:RC[59])=(RC[58]),(RC[58]),IF(Max(RC[57]:RC[59])=(RC[59]),-(RC[59]),))
but
=IF(MAX(RC[59]:RC[63])=(RC[60]:RC[61]),(RC[60]:RC[61]),IF(MAX(RC[59]:RC[63])=(RC[62]:RC[63]),-(RC[62]:RC[63]),))
aparently it won't work because it refers to a range of cells. I've tried various methods of working around it, but have hit a wall - can anyone suggest a solution for the above code or some VB code that will do the same job?
Many thanks
Hugh