Need help matching Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of numbers, this list has positive numbers that are being write
of by a same negative number, this is

156.35 to -156.35

I need to show all the positive numbers that have a match as 0, the rest of
none match as it is?
 
How about creating a new column with =ABS( column with list in it )
Then sort on the ABS column.
HTH,
Gary Brown
 
Back
Top