how to find text vaues for a given grade?


S

sumesh56

I have a worksheet with slno(A1),names(B1),Sex(Male/Female)(C1).an
some adjectives of persons in D1:H1.These adjectives are column heading
of D:H. In col I ,i have to get the result of a formula(the tw
adjectives seperated by a comma)then in col J, i will award grade to th
persons "A", "B" AND "C". When i award the grades in col J, any tw
adjectives should be printed in col I. in the adjoining cells of colum
I, there should appear other adjectives not the just used ones. i
should continue till the list ends.what i mean to say is, the adjective
in column I, should differ row by row.
TASK-1
1.when i put "A", "B" OR "C" in J2,any two adjectives should appear i
cell I2.
2.when i put "A", "B" OR "C" in J3,any two adjectives other than th
just used ones should appear in cell I3.
3.when i put "A", "B" OR "C" in J4,any two adjectives other than th
just used ones should appear in cell I4.
----------------------------
kindly see the attached "FIND TEXT VALUES FOR GRADESsample_1.xlsx
-----------------------------------
TASK-2
------
Assumes that when i put "B" in cell J2 excel gives the adjectives (0
numbers seperated by a comma)in cell I2.
The second task requires excel to allot numerical values to th
adjecties in the corresponding cells. The values are "A"=5, "B"=4 and
"C"=3.
If i allot "A" in cell J2, and In cell I2 ,if excel gives tw
adjectives as polite and obedience, it should give 5 each in th
corresponding cells (C2 and D2)
If i allot "B" in cell J2, and in cell I2, if excel gives two adjective
as liberal and intelligent, then it should show 4 each in th
corresponding cells E2 and F2.
If i allot "c" in cell J2, and In cell I2 ,if excel gives tw
adjectives as obedience and consistent then it should give 3 each i
the corresponding cells (D2 and H2)
----------------------
please see the attached "FIND NUMERICAL VALUES FOR TEXT ENTERED
sample_2.xlsx.
thanks
--------------------------

+-------------------------------------------------------------------
|Filename: FIND TEXT VALUES FOR GRADES.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=821
|Filename: FIND NUMERICAL VALUES FOR TEXT ENTERED.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=822
+-------------------------------------------------------------------
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top