Hi

I have created a survey where I have 7 Basic Statements. I have created 21 "Questions" which are in reality all of the statements laid out in unique pairs. The respondent is asked to go through the question pairs (Radio List with 2 options each) and choose the one that resonates most strongly with them. So they are asked to evaluate A vs B, A vs C, A vs D, A vs E, A vs F, A vs G, B vs C, B vs D, B vs E etc.

At the end of this process I have created a Formula question which effectively lists the answers that have been given to each evaluation. This isn't very sophisticated it just says {AandB} {AandC} {AandD} {AandE} through to {FandG}... These are my very uncreative Question Codes.

My question is, can I now in some way read through this and perform a count of how many times each statement has been chosen and then provide that as output such as:

You Selected Statement A 3 times.
You Selected Statement B 4 times.
You Selected Statement C 6 times.
You Selected Statement D 1 times.
You Selected Statement E 2 times
You Selected Statement F 0 times
You Selected Statement G 5 times.

Supplemental question: If it is possible to do the above, would it also be possible to sort this output so it was in Descending frequency order?

Thanks in advance for any help given.

Steve

Just bouncing this up as I'm sort of stuck if nobody has any ideas on how I can do this? Or whether I should abandon this and look for another solution that would allow me to do it.

I'm could I do it by using IF statements in some way?

Thanks
Steve

Have a look at Expression Manager - access to functions - count ()

This is untested (done from phone), but for the total of answer code "a" selected, try something like:

Thanks for the pointer Tony you are a STAR!

For completeness on this bit here is what I've done and it works

{AandB} {AandC} {AandD} {AandE} {AandF} {AandG}

{BandC} {BandD} {BandE} {BandF} {BandG}

{CandD} {CandE} {CandF} {CandG}

{DandE} {DandF} {DandG}

{EandF} {EandG}

{FandG}

The number of times you selected A was {count(AandB=='A', AandC=='A', AandD=='A', AandE=='A', AandF=='A', AandG=='A')}

The number of times you selected B was {count(AandB=='B', BandC=='B', BandD=='B', BandE=='B', BandF=='B', BandG=='B')}

The number of times you selected C was {count(AandC=='C', BandC=='C', CandD=='C', CandE=='C', CandF=='C', CandG=='C')}

The number of times you selected D was {count(AandD=='D', BandD=='D', CandD=='D', DandE=='D', DandF=='D', DandG=='D')}

The number of times you selected E was {count(AandE=='E', BandE=='E', CandE=='E', DandE=='E', EandF=='E', EandG=='E')}

The number of times you selected F was {count(AandF=='F', BandF=='F', CandF=='F', DandF=='F', EandF=='F', FandG=='F')}

The number of times you selected G was {count(AandG=='G', BandG=='G', CandG=='G', DandG=='G', EandG=='G', FandG=='G')}

Anybody got any ideas on how I can sort these in descending count order?

Thanks in advance
Steve