I have survey responses that I downloaded in excel format. One of the columns has response in form of 27 groups each group with three alphabet letters. They are not really words but initials of words grouped together. I want to grade the responses based on their correctness. I am trying to use if statement to tell the program to look for these 27 groups of letters, the groups can be in any order and the letters in the group can be in any order. I know that IF with find will do this to some extent but the issue is it is looking for the same order of the group and same order of letters in each group which I dont want. How do I do this?
Example of the responses in the cell
abc adg sdf asd
(abc) (gda) (fds) (ads)
acb/adg/sdf/sda/
I want the program to ignore parenthesis, slashes if any as well.
Example of the responses in the cell
abc adg sdf asd
(abc) (gda) (fds) (ads)
acb/adg/sdf/sda/
I want the program to ignore parenthesis, slashes if any as well.
Last edited: