S

#### sumesh56

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

+-------------------------------------------------------------------