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.

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

"nastech" wrote:

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.

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

"Barb Reinhardt" wrote:

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

"nastech" wrote:

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.

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..

"Barb Reinhardt" wrote:

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

"nastech" wrote:

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.

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

"Barb Reinhardt" wrote:

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

"nastech" wrote:

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.

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

might be working


"Barb Reinhardt" wrote:

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

"nastech" wrote:

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.

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

"Barb Reinhardt" wrote:

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

"nastech" wrote:

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.