LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Senior Member
 
Posts: 118
Default numerical value to text description

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.
Attached Files
File Type: zip NUMERCAL TO WORD VALUEee.zip (7.1 KB, 29 views)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bubble Chart with text as description of an axis schleimer Charts and Charting in Excel 2 April 16th 08 08:43 AM
I am trying to abbreviate text in my description column. Antonio Excel Worksheet Functions 3 February 28th 07 01:56 AM
from numerical to word description Pei Pei Excel Discussion (Misc queries) 2 August 9th 06 11:08 AM
Numeric Cell Value with text description Paco86 Excel Discussion (Misc queries) 2 June 21st 06 12:00 PM
Numerical Value to text no0dles New Users to Excel 7 April 25th 06 03:24 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"