Sorting Cells on letters and numbers and placing result in one of 3 columns
 

Hi all, maybe someone can work this out I have a sheet as below
I need a bit of sorting when user puts in how many in A1, code CBO in
A4, I want the numbers to go into the appropriate columns 10 goes into
A8.. 10 goes into A9 and so on.

I have a another sheet that has all the codes listed. How do I manage
to have those numbers appear in the appropriate cells???

A1 A4 A7 A8 A9

10 CBO 10

10 KD
10

5 CB
5

4 CBO 4

2
KD 2

3 IB 3


Thanks so much
Regards
Stephen

Sorting Cells on letters and numbers and placing result in one of
 

=IF(AND(ISNUMBER(A1),A4="CBO"),A1,"")

copy all the way down as far as needed


"pano" wrote:

Hi all, maybe someone can work this out I have a sheet as below
I need a bit of sorting when user puts in how many in A1, code CBO in
A4, I want the numbers to go into the appropriate columns 10 goes into
A8.. 10 goes into A9 and so on.

I have a another sheet that has all the codes listed. How do I manage
to have those numbers appear in the appropriate cells???

A1 A4 A7 A8 A9

10 CBO 10

10 KD
10

5 CB
5

4 CBO 4

2
KD 2

3 IB 3


Thanks so much
Regards
Stephen

Sorting Cells on letters and numbers and placing result in one of
 

On Feb 7, 2:29 pm, Teethless mama
wrote:
=IF(AND(ISNUMBER(A1),A4="CBO"),A1,"")

copy all the way down as far as needed



"pano" wrote:
Hi all, maybe someone can work this out I have a sheet as below
I need a bit of sorting when user puts in how many in A1, code CBO in
A4, I want the numbers to go into the appropriate columns 10 goes into
A8.. 10 goes into A9 and so on.

I have a another sheet that has all the codes listed. How do I manage
to have those numbers appear in the appropriate cells???

A1 A4 A7 A8 A9

10 CBO 10

10 KD
10

5 CB
5

4 CBO 4

2
KD 2

3 IB 3

Thanks so much
Regards
Stephen- Hide quoted text -

- Show quoted text -

I should have perservered another 10 minutes as I got it as follows

=COUNTIF(COUNT!I37:I59,J5)*F5
Goes to Count sheet has a look for Code in range compares it with J5
and if it matches takes number value in F5 and puts it in cell L5.

Easy was'nt it... like not !!!!! My head is spinning