Excelers? Is it possible to sort rows by a forumla that's based on a column, without having to put the formula expressly within a column itself?
Posted by
prayformojo (aka mayhem)
Aug 15 '12, 11:13
|
say a column has positive and negative integers.
I want to sort by the absolute value of the integer.
I could insert a column, populate it with the formula,
sort by the column and then hide it....
I was just trying to do it a little more efficiently and sort by the formula on-the-fly.
any way to do this?
|
Responses:
|