| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separating +ve and -ve numbers into two columns
I have a large column of numbers, some postive and some negative. I would
like to separate these into two columns, one for positive and one for negative. Is there a quick way of doing this? -- David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
separating +ve and -ve numbers into two columns
Put something like this in B1
=if(a1<0,a1,"") and in C1 =if(a1=0,A1,"") and drag down. I'm not sure how 0's should be treated, though Prospect wrote: I have a large column of numbers, some postive and some negative. I would like to separate these into two columns, one for positive and one for negative. Is there a quick way of doing this? -- David -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
separating +ve and -ve numbers into two columns
David
You could use a formula approach eg in col B: =If(A1<0,A1,"") and col C: =IF(A1=0,A1,"") copied down. Then you'd have to copy and paste values. Simple, but it works! Richard Prospect wrote: I have a large column of numbers, some postive and some negative. I would like to separate these into two columns, one for positive and one for negative. Is there a quick way of doing this? -- David |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
separating +ve and -ve numbers into two columns
I guess you could put =IF(A1=0,A1,"") in one column for the +ve numbers and
=IF(A1<0,A1,"") in the next column for the -ve numbers and copy both down to your last entry "Prospect" wrote: I have a large column of numbers, some postive and some negative. I would like to separate these into two columns, one for positive and one for negative. Is there a quick way of doing this? -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lots of numbers and columns | Excel Discussion (Misc queries) | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Separating Numbers | Excel Worksheet Functions | |||
| In Excel can you merge two columns i.e. street numbers and addres. | Excel Worksheet Functions | |||
| how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions | |||
Linear Mode
