View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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