Forum Discussion

Yasmin Behchet's avatar
Yasmin Behchet
Copper Contributor
Mar 07, 2017

Best way to sort data if the data/cells in one column depend on the data/cells in another column?

Normally I'd make a formula, but I need to arrange the rows where the data in both colums are either the same or more. Not sure how to sort this. Please advise

excel
Formulas and Functions

3 Replies

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 07, 2017

    Hi Yasmin,

     

    Just use the Sort feature in Excel.

    but, before use it, make sure that your columns are adjacent.

    If you want to learn more about the Sort Feature, just follow this link:

    http://bit.ly/2lSfqp3

    • Yasmin Behchet's avatar
      Yasmin Behchet
      Copper Contributor
      Mar 07, 2017
      Thanks Haytham but I need to arrange the rows so that if the data in Col B and D match they go to the top and if greater than D-B they go to the bottom. Can't see an option in sort, unless I change their colour.
      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor
        Mar 07, 2017

        Hi,

         

        In column C write this logical formula:

         

         

        =A2=B2

         

        and then copy it down.

         

        It's will give you TRUE, if the A2=B2, and FALSE if it not.

        When you finish, you can now sort the TRUE/FALSE column from Z to A to get what you want.

Resources