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.