numerical value to text description

[sumesh56]

I wanted to get the following from a worksheet. i have slno,names i
A:B.and some adjectives of persons in C:H. in col I i have to counta th
number of numerical entries from C:H.(it should not coun
zero)(avoiding the zero)then in col J, i have to get the average scor
that too with two decimals. and lastly in col K, i have to get th
entries of the concerned adjectives for which numericals have bee
given.If I2=2 then in K2 there should be two text descriptions.I
I3=5,then K3 should have 5 text descriptions which are given as co
headings in C:H.thanks
i am attaching the sample excel sheet

+-------------------------------------------------------------------
|Filename: NUMERCAL TO WORD VALUEee.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=819
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Sumesh,

Am Tue, 26 Mar 2013 02:37:20 +0000 schrieb sumesh56:

I wanted to get the following from a worksheet. i have slno,names in
A:B.and some adjectives of persons in C:H. in col I i have to counta the
number of numerical entries from C:H.(it should not count
zero)(avoiding the zero)then in col J, i have to get the average score
that too with two decimals. and lastly in col K, i have to get the
entries of the concerned adjectives for which numericals have been
given.If I2=2 then in K2 there should be two text descriptions.If
I3=5,then K3 should have 5 text descriptions which are given as col
headings in C:H.thanks

for counting without zero:
=COUNTIF(C2:H2,"<>0")
for Average without zero:
=SUM(C2:H2)/COUNTIF(C2:H2,">0")
for the adjectives:
=IF(C2>0,$C$1&", ","")&IF(D2>0,$D$1&", ","")&IF(E2>0,$E$1&", ","")&IF(F2>0,$F$1&", ","")&IF(G2>0,$G$1&", ","")&IF(H2>0,$H$1,"")



Regards
Claus Busch