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
|