ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need help matching Numbers (https://www.excelbanter.com/excel-programming/325893-re-need-help-matching-numbers.html)

Gary Brown[_8_]

Need help matching Numbers
 
How about creating a new column with =ABS( column with list in it )
Then sort on the ABS column.
HTH,
Gary Brown


"MESTRELLA29" wrote in message
...
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?





All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com