Wednesday 20 September 2017

microsoft excel - How to split numbers into columns with negative and positive values, without empty cells?

Given positive and negative values in column A of an Excel sheet, I want column B to list the positive values from column A, and column C to show the negative values, in the order in which they appear in column A.


However, I don't want any empty cells in columns B and C.


So, I do NOT want:


   A     B     C
----------------
All >=0 <0
100 100
-300 -300
-800 -800
900 900
700 700
-200 -200
900 900

But instead, I want:


   A     B     C
----------------
All >=0 <0
100 100 -300
-300 900 -800
-800 700 -200
900 900
700
-200
900

No comments:

Post a Comment

Where does Skype save my contact&#39;s avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...