Excel - Separate Positive and Negative numbers in the same column

[@whentheskittlesfightback]

Great video, and honestly as a SUMIF lover, that last tip was wildly relevant! I never considered how easy it could be to change the formula when need be!

[@1Enjaz]

Chris, You make it easy! I sure will be watching more of your videos.Thank you.

[@elizabethpietrzak412]

Thank you Chris! You just made my whole tax year easier!

[@mansmagique]

Thank you - this just saved my night!

[@begonial6151]

Love the find and replace. Never thought of trying that. Your videos are great.

[@estellebotha7199]

Thank you so much, you just made my life easier, the Conditional formatting is exactly what I needed

[@nawsarah-u6b]

Thank you . your tutorial assist me to solve my exercise :D

[@RamsayHakim]

brilliant- thank you

[@ChrisMenardTraining]

You're welcome!

[@mountainwolvesbd]

Great video

[@PetterHallden]

Hi Chris, I have a question similiar to what you showed here. If you have both negative and positive numbers in a column and want to change the neagtives into positive but at the same time keep the positve numbers in the column, how would you do that?

[@ChrisMenardTraining]

You could sort smallest to largest. The negatives would be at the top. Type -1 and copy it. Select the negative cells and Paste Special multiple would make them positive. You could also not sort them, and write an IF function to make any number

[@pinuschen2806]

@4:41 anyone knows or have a link to tutorial of how to do this in google spread?

[@christopherpadilla8439]

I’m trying to make a list that automatically takes away negatives from the other list. What formula would I use then?

[@justinmcmurray]

What if you were trying to do a sumif on the merchants and only wanted to return positive numbers in one cell? What would that look like?

[@ChrisMenardTraining]

=SUMIF(B2:B6,">0") would work. Here is a screenshot also drive.google.com/file/d/1GjO16_UfUpwYuLmbwKY_kMZMxvfuU-BR/view?usp=drivesdk

[@MrKutty-m6z]

Incase Another value Format Same value or Not Equal value in this Case How to Workout the If Function in same Column

[@richardhay645]

I made a comment yesterday and you replied to it. A few hours later both my comment and your reply vanished!!??,? Not a big deal but very strange. I've known of that happening on other channels and have seen users complain. It's happened to me twice before.KZbin??? Or what??

[@gamking7987]

if happens every time you edit the video after someone left a comment, it will be deleted.