+ Reply to Thread
Results 1 to 6 of 6

Sorting a list accordiong to total value and variance

  1. #1
    Registered User
    Join Date
    09-01-2020
    Location
    Munich, Germany
    MS-Off Ver
    365 Excel Version 2007
    Posts
    6

    Unhappy Sorting a list accordiong to total value and variance

    Dear all,

    Is there a way to sort rows in an excel sheet from Z-A according to, first, the total value in F, which is a sum of the value in C:E and, then, the variance between the values in C, D, E?

    For example, I would like a row with the total sum of 12 in F through 4 4 4 (variance = 0) in C:E to rank higher than a row with the total sum of 12 in F through 5, 3, 4 (variance = 3)

    Unbenannt.JPG

    Any ideas on how to do this?
    Attached Files Attached Files
    Last edited by Corgiboy; 12-01-2020 at 06:21 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Sorting a list accordiong to total value and variance

    With a helper column? Is that OK? How can you derive a value of variance of 3 for 5,4,3???
    Glenn



  3. #3
    Registered User
    Join Date
    09-01-2020
    Location
    Munich, Germany
    MS-Off Ver
    365 Excel Version 2007
    Posts
    6

    Re: Sorting a list accordiong to total value and variance

    That would be absolutely fine. I also meant 1, not 3 Thanks for noticing.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Sorting a list accordiong to total value and variance

    Using data/sort, as per image.
    Attached Images Attached Images
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-01-2020
    Location
    Munich, Germany
    MS-Off Ver
    365 Excel Version 2007
    Posts
    6

    Re: Sorting a list accordiong to total value and variance

    This works perfectly. Thank you so much for the help!

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Sorting a list accordiong to total value and variance

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 04-09-2021, 01:59 AM
  2. Adding a Calculated Filed for Variance % on the Grand Total using VBA
    By e4excel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-07-2018, 02:27 PM
  3. Why is there a variance here for total year?
    By Katie620 in forum Excel General
    Replies: 9
    Last Post: 11-28-2017, 10:22 AM
  4. [SOLVED] Find the date of a variance amount over a limit and count the days since the variance.
    By avidcat in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-21-2013, 12:00 PM
  5. Replies: 3
    Last Post: 10-12-2012, 01:55 AM
  6. Replies: 5
    Last Post: 11-17-2010, 09:03 PM
  7. Variance Total for less than complete year?
    By Enzo in forum Excel General
    Replies: 1
    Last Post: 09-01-2005, 05:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1