Results 1 to 4 of 4

Thread: Sort a table with a formula column

  1. #1

    Sort a table with a formula column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    What is the best way to sort a table with a formula column?

    I have a table with columns:

    - Market name
    - Criteria 1 (value)
    - Criteria 2 (value)
    - Criteria 3 (value)
    ...
    - Score (formula calculating a weighted average based on criteria 1, 2, 3...)

    I need to sort a table by score (from higher to lower).

    I would appreciate any help on this

  2. #2
    Good afternoon,

    I think if you make references to the individual cells (instead of [Column 1]) it should sort properly.

    Best of luck,

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    So simply sorting through Data|Sort and selecting that column for sorting in descending order doesn't work?


  4. #4
    Thanks for the advise. I found out what was wrong, and it works now.

Posting Permissions

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