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?
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
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.RUclips??? Or what??
Hello i like the fact that you don't play stupid loud music as part of your videos. A lot of people only have 1 laptop/computer. So we watch you on our tiny phone screens, while trying to type on our laptops. That means that 1cm by 3cm cell that you are typing in on your laptop. Becomes a blurry 0.3mm by 0.7mm cell on the phone screen. Too small to see what you are typing. Next time try zooming in on the cell, or enlarging the sheet. Your making these videos so people can see them. If people cannot see what you are typing. Then it is a waste of time watching your videos. Good luck.
Chris, You make it easy! I sure will be watching more of your videos.Thank you.
Thank you Chris! You just made my whole tax year easier!
Thank you so much, you just made my life easier, the Conditional formatting is exactly what I needed
Love the find and replace. Never thought of trying that. Your videos are great.
Thank you - this just saved my night!
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?
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
Thank you . your tutorial assist me to solve my exercise :D
I’m trying to make a list that automatically takes away negatives from the other list. What formula would I use then?
Great video
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?
=SUMIF(B2:B6,">0") would work. Here is a screenshot also drive.google.com/file/d/1GjO16_UfUpwYuLmbwKY_kMZMxvfuU-BR/view?usp=drivesdk
brilliant- thank you
You're welcome!
@4:41 anyone knows or have a link to tutorial of how to do this in google spread?
Incase Another value Format Same value or Not Equal value in this Case How to Workout the If Function in same Column
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.RUclips??? Or what??
if happens every time you edit the video after someone left a comment, it will be deleted.
Hello i like the fact that you don't play stupid loud music as part of your videos.
A lot of people only have 1 laptop/computer.
So we watch you on our tiny phone screens, while trying to type on our laptops.
That means that 1cm by 3cm cell that you are typing in on your laptop.
Becomes a blurry 0.3mm by 0.7mm cell on the phone screen.
Too small to see what you are typing.
Next time try zooming in on the cell, or enlarging the sheet.
Your making these videos so people can see them.
If people cannot see what you are typing.
Then it is a waste of time watching your videos.
Good luck.