Issues creating formulas.

  • Thread starter Thread starter Ken G
  • Start date Start date
K

Ken G

I have another : Formula #3
I have a small table from col A to C
and Rows 1 to 16..my final analysis
Col A
Rows 1 to 16 I have a code from 0 to 15 primary manual input.
Col B
Rows 1 to 16 I have a description of each code
Col C
Rows 1 to 16, I have a numerical count

Col Z ($P35:$P2000)
I do a manual input in this col for the codes 0 - 15 of Col A
if I put say code 4 in the Z col I want I want it to copy the description of
code 4 Col B to its corresponding row in col AC

Now if I input several codes in the same cell, such as 4,7,15..then I want
it to copy the descriptions of each of those codes in the corresponding row
of the code in Col AC

then I want it to take all the codes in ($P35:$P2000) and count them and
place the value of their corresponding row in COL C

Does this make sense
 
in Col C

1 =countif($P$35:$P$2000,A1)
2 =countif($P$35:$P$2000,A2)
..
..
..
16 =countif($P$35:$P$2000,A16)
 
Back
Top