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