Hi,
I've concatenated text strings in column B with those in Column C and would like to know what formula I can use to assign a unique value to the combined string.
Example
Col Col Col Col Function for result below?
B C D E F
Cat1text Question1text Cat1textQuestion1text Cat1textQuestion1text returns a '1'
Cat1text Question2text Cat1textQuestion2text Cat1textQuestion2text returns a '2'
Cat1text Question3text Cat1textQuestion3text Cat1textQuestion3text returns a '3'
Cat2text Question1text Cat2textQuestion1text Cat2textQuestion1text returns a '4' etc
There are 12 categories and a total of 61 questions spread in varying amounts among these categories (eg cat1 has 3 unique questions attached to it, cat 2 has 4 unique questions etc etc)
The categories and questions may be repeated in the list and after sorting alphabetically by Category in Column B, I would like to do a count of all the '1''s in col F between say F1:f20000 in say f20001, all the 2's in column F in h200001, all the '3's in column F in i200001 etc etc
Many thanks
I've concatenated text strings in column B with those in Column C and would like to know what formula I can use to assign a unique value to the combined string.
Example
Col Col Col Col Function for result below?
B C D E F
Cat1text Question1text Cat1textQuestion1text Cat1textQuestion1text returns a '1'
Cat1text Question2text Cat1textQuestion2text Cat1textQuestion2text returns a '2'
Cat1text Question3text Cat1textQuestion3text Cat1textQuestion3text returns a '3'
Cat2text Question1text Cat2textQuestion1text Cat2textQuestion1text returns a '4' etc
There are 12 categories and a total of 61 questions spread in varying amounts among these categories (eg cat1 has 3 unique questions attached to it, cat 2 has 4 unique questions etc etc)
The categories and questions may be repeated in the list and after sorting alphabetically by Category in Column B, I would like to do a count of all the '1''s in col F between say F1:f20000 in say f20001, all the 2's in column F in h200001, all the '3's in column F in i200001 etc etc
Many thanks
Last edited: