I'll try and explain what I am doing. Any help would be appreciated...
I have data that is imported into cells A1:A10 that can be positive, negative, or zero. Here is an example:
A1=5
A2=2
A3=-2
A4=0
A5=3
A6=-1
A7=0
A8=1
A9=0
A10=-3
In cells C1:C10 I would like to see the following results based on the entries in A1:A10. All positives listed first, blank line, then negatives listed. Zero amounts are disregarded. This is what I would want the above to produce in cells C1:C10:
C1=5
C2=2
C3=3
C4=1
C5=Blank
C6=-2
C7=-1
C8=-3
C9=Blank
C10=Blank
Thanks in advance,
Sam
Bookmarks