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