Forum Discussion
Removing positive and negative values in excel
Hello. I am currently dealing with an excel sheet where there is multiple vendors for which each contain innumerable positive and negative value transactions. I would like a formula/shortcut tha...
I didn't understand you properly.
One way is having absolute values using the ABS() formula.
If you can share some sample data and what your desirable output would be good for us to assist you better.
One way is having absolute values using the ABS() formula.
If you can share some sample data and what your desirable output would be good for us to assist you better.
Kindly direct me to a link where I can retrieve the ABS approach. If this doesn't help I'll revert
- ABS() formula converts negative numbers into positive numbers.
But, with sample data would be better to understand your doubt.