Multiple Criteria to Classify groups
you seem to be pleased with my suggestion and I'm glad I could help. thank
you for the feedback.
"Karoline" wrote:
OH MY GOD!!!!
IT WORKED! I am so excited!!!
Thanks a LOOOOOOT and I send you a big HUG!!!
You have no Idea how much you helped me!!!
All the best!!!
--
KBZ
"Mike H" wrote:
Hi,
If I've understood correctly then you could try this. Build a table
somewhere out of the way looking something like this:-
1 Dance
11 Music
111 Song
1V This
V That
VI The
V111 Other
V111 Rock
1X Pop
X Classical
In my case it's in I1 to J10
The this formula in B1
=VLOOKUP(A1,$I$1:$J$10,2,FALSE)
Now if you type your Roman number in A1 it will return the adjacent text
from the table. i.e 1X returns Pop.
Drag the formula down as required.
Mike
"Karoline" wrote:
HI! I am a dummy beginner but very interested in improve my skills. I have
been 4 hours trying to understand the logic on multiple criteria formulas and
I am afraid I am almost going to give up... Someone around could PLEASE help
me?
Suppose I have 10 different type of groups to classify a loooong list of
students according to their interests as follows:
A1: A10 B1:B2
I painting
II dancing
... ...
X reading
My first question is if I can relate text information (I, II, III, IV...X)
with other text info (B1:B10) so I can obtain an automatic fill of one colum
A or B...
I mean if after I write for example painting the opposite colum will
automatically write the group (I) or the opposite: if I introduce the group
i.e. II, inmediately I can know the activity (dancing)?
I had used a replacement tool before, with other kind of tables BUT after
finishing entering all the information in the chart : I mean after finishing
a list I have used the IF (A1:A10="done"), OK, "error"),
how ever this time I can have 10 diferent possibilities "I", "II",
"III"....."X" and I have being giving circles to relate both columns in a
single step.
As the experts of this space might have notice due to my long mail, I have
few experience, but would really appreciate some help in this! ! !
ps: So far I am deciding one by one the student activity, but if you teach
me, my hope is to make a formula in such a way that with a combination of
letters I could know faster the best group to locate each student, by
defining the criterias (i.e. the student will paint if he love painting, is
not interested in physical activities and has a scolarship--- LP, NO Phy and
SCHP...
I will wait to see if someone can help me at the other side of the world.
Thank you,
Karoline
KBZ
|