Excel Question
CF
Tags:
(Neanderthal, 2,773
Points)
on 8/8/12 at 3:47pm
How do I sort the last column of a table by the value of the sum of the formula from smallest to largest when the table is only formulas?
I think this is a stupid question but I really can't find the answer anywhere





Not sure exactly what you're
Not sure exactly what you're trying to do, but I don't think you can really sort formulas, because sorting will likely change the formulas depending on how they're set up. You could paste values and sort, create a pivot table that refers to the original table and sort that, or have another column that identifies the ordering of the last table column (such as using RANK, LARGE, SMALL, etc) and then do vlookups that read the ordering volumn in the desired order and pull their corresponding vals.
In headaches and in worry
Vaguely life leaks away
And Time will have his fancy
Tomorrow or today.
speaking of excel
speaking of excel problems...
how do you COUNTA given the criteria of two columns, is this possible?
Baby you're the perfect shape, baby you're the perfect weight. Treat me like my birthday, I want it this way and I want it that way. It makes a man feel good baby.
R0bin: speaking of excel
speaking of excel problems...
how do you COUNTA given the criteria of two columns, is this possible?
You can do an array formula using a combination of IF, AND, ISBLANK, COUNT
In headaches and in worry
Vaguely life leaks away
And Time will have his fancy
Tomorrow or today.
R0bin: speaking of excel
speaking of excel problems...
how do you COUNTA given the criteria of two columns, is this possible?
you could do a countifs and have one of your criteria be "<>"&0 (doesn't equal to zero).. (blank cells are = to 0).
This to all my hatin' folks seeing me getting guac right now..
Cruncharoo: R0bin: speaking
speaking of excel problems...
how do you COUNTA given the criteria of two columns, is this possible?
you could do a countifs and have one of your criteria be "<>"&0 (doesn't equal to zero).. (blank cells are = to 0).
Careful now...your formula would ignore values that actually are 0...
In headaches and in worry
Vaguely life leaks away
And Time will have his fancy
Tomorrow or today.