N
Nastech
hi, not sure about math for doing a reverse sort, with the following example
small numbers turn to large.., with a reciprocol type formula and vice-versa,
using: =TEXT(10^3/DB841,"0000")
tested for numbers pos 1-1000/(4 places) & neg numers, negs come up neg,
but do not sort to bottom as neg (Problem is they are sorting same as/mixed
in with positive numbers),
output examples: (sorts to same order)
31 0032
-29 -0048 (sorts as if "-" sign not there
29 0048
19 0053
sorting formula example:
=IF($DB$2>0,TEXT(10^3/DB9,"0000"),9)&IF($DA$2>0,TEXT(10^3/DA9,"0000"),9)& ...
small numbers turn to large.., with a reciprocol type formula and vice-versa,
using: =TEXT(10^3/DB841,"0000")
tested for numbers pos 1-1000/(4 places) & neg numers, negs come up neg,
but do not sort to bottom as neg (Problem is they are sorting same as/mixed
in with positive numbers),
output examples: (sorts to same order)
31 0032
-29 -0048 (sorts as if "-" sign not there
29 0048
19 0053
sorting formula example:
=IF($DB$2>0,TEXT(10^3/DB9,"0000"),9)&IF($DA$2>0,TEXT(10^3/DA9,"0000"),9)& ...