Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|