Ascending Sort formula, change to neg #: descending sort..

[Guest]

Hi, have a project where intensive sort formula work needs rest of formula
ascending (for that worker column), but need to descending sort item within.
sample of what have: (thanks)

Problem is getting a number column to sort in descending order (i.e. make a
negative number so an "Ascending" sort will handle the other parameters as
ascending). 1st part ascending, only 2nd part needs change to descending.

=IF($Z$2=1,AA9,9)&IF($CU$2=1,-CU9*10^-11,9)

have used variations with TEXT(CU9,"00000000000") and trying to put the
negative sign around different spots, not getting to work.

 

[Guest]

You're question isn't very clear. You may want to clarify it a bit.

 

[Guest]

thanks, sorry, not sure how to word; example is short version placed in a
worker column for sorting, have an extended list of columns sorted under
conditions of simply putting a "1" in the 2nd cell at top of that column &
separating items in 1 formula with the andpersand (sp): &; that aside, I
pick that worker column to sort (L in my case), sort is in ascending order
for that 1 worker column.

the 2nd item in the formula is a number ranging from thousands to 1 or 10
billion.
desire is to sort the column it refers to in descending order. placing
various numbers in the column: CU (descending) and sorting on: L (the
phyisical sort: ascending). Goal is to get CU to sort descending, within
L, in descending order.
hows that thanks

 

[Guest]

If I am correct, point is that sorting negative numbers, Ascending, sorts
from large to small, and in essence a descending absolute value?? -3, -2,
-1, 0, 1 2 3 ..
think I might be on wrong track..

 

[Guest]

is this more of a math question, suppose some variation of 1/.. x10..

 

[Guest]

=IF($CU$2=1,1/(CU9*10^-11),9)

might be working

You're question isn't very clear. You may want to clarify it a bit.

 

[Guest]

This should do it, gets answers to show for 10's of billions...
=IF($CU$2=1,TEXT(1/(CU435*10^-11),"0000000"),9)