+ Reply to Thread
Results 1 to 1 of 1

numerical value to text description

  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    542

    numerical value to text description

    I wanted to get the following from a worksheet. i have slno,names in A1:B1.and some adjectives of persons in C1:H1 for which i will make entries in the form of numeric value . in col I1(total entries) i have to counta the 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, in K2 there should be two text descriptions for the value. if I3=5, in K3 there should be 5 text descriptions(which are given as column headings)
    i am attaching the sample excel sheet.
    Attached Files Attached Files
    Last edited by sumesh56; 03-25-2013 at 10:20 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1