Sorting with formula

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 1 of 1

Thread: Sorting with formula

  1. #1
    New Member
    Join Date
    Mar 2013
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Sorting with formula


    I have a range of rows that contain formulas. I want to sort the rows by the formula outputs but I want to still keep the formulas referencing to the correct destinations. Currently, when i just apply the sorting, formulas reference to the same CELLS, but not the needed destinations.

    I can't copy / paste special (values) since I need to keep the formulas and the correct links.

    Is there a way I can sort that rows by the value of the formula outputs in the cells and keep the formulas?

    Many thanks!

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts