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.
Bookmarks