Formula to separate numbers in columns

[serge]

Hi everyone,

I need some help with a formula please.
In column A, I have numbers, and I would like to separate them in column C and D as is:

All numbers from 1 to 7 would be in column C, or if the number is higher = blanc cell.
and all numbers from 8 and up would be in column D, or if below = blanc cell.

Thank you. Serge.

 

[hiker95]

serge,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net

 

[Aladin Akyurek]

Hi everyone,

I need some help with a formula please.
In column A, I have numbers, and I would like to separate them in column C and D as is:

All numbers from 1 to 7 would be in column C, or if the number is higher = blanc cell.
and all numbers from 8 and up would be in column D, or if below = blanc cell.

Thank you. Serge.

Try...

C2, copy down:

=IF(ISNUMBER(A2),IF(AND(A2>=1,A2<=7),A2,""),"")

D2, copy down:

=IF(ISNUMBER(A2),IF(A2>=8,A2,""),"")

 

[serge]

Hi Aladin

Thank you very much, your 2 formulas work perfectly for what I need.

 

[serge]

hiker95,

Thank you for the tip I will use it next time.

 

[Aladin Akyurek]

Hi Aladin

Thank you very much, your 2 formulas work perfectly for what I need.

Great. Thanks for the feedback.