Excel ?

Discussion in 'Trading Software' started by hopback, Mar 16, 2006.

  1. hopback

    hopback

    I have the following formula perform a data sort.

    {=(ADDRESS(MIN(IF(E2:E483=G2,ROW(D2:D483))),COLUMN(D2:D483),4))}

    How do I convert the resulting cell address to the cell value. I thought that I'd done this before but, for the life of me, I can't figure it out.

    Thanks in advance.
     
  2. hopback

    hopback

    should be
    (D2: D483) without the space

    not (D2:D483)

    damn smilies...
     
  3. hopback

    hopback

    couldn't figure it out so I rewrote the formula.

    {=MAX(($E$2:$E$483=H2)*($F$2:$F$483))}

    cleaner this way