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