Excel ?

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

  1. hopback


    I have the following formula perform a data sort.


    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


    should be
    (D2: D483) without the space

    not (D2:D483)

    damn smilies...
  3. hopback


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


    cleaner this way