sorting column built by formula

  • I have used formulas to create a worksheet from information from several other worksheet. Now, I need to sort the sheet, using data from one column.

    How do I sort data, that is in formula form?

  • because your formulae are stuffed when you sort normally ?

    try "sorting" on your resultant info using a combination of =RANK and =VLOOKUP

    I use these all the time in my leagues and it works a treat.

    Post up some sample data (the results of your formulae) and how you want them to then appear after a sort and we can run you through some options

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!