numerical value to text description
1 Attachment(s)
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
i am attaching the sample excel sheet. |
numerical value to text description
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(C20,$C$1&", ","")&IF(D20,$D$1&", ","")&IF(E20,$E$1&", ","")&IF(F20,$F$1&", ","")&IF(G20,$G$1&", ","")&IF(H20,$H$1,"") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com