# Sorting a list accordiong to total value and variance

1. ## 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?

2. ## 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???

3. ## 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. ## Re: Sorting a list accordiong to total value and variance

Using data/sort, as per image.

5. ## Re: Sorting a list accordiong to total value and variance

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

6. ## Re: Sorting a list accordiong to total value and variance

You're welcome.

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.

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