Sort data using a formula and produce output by rank

[Bugy6999]

Hi,
I would like to sort data in based on a rank criteria:

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]responds to questions[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]uses pronouns correctly[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]uses advanced propositions[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

2 = usually
1 = sometimes
0 = never

I would like to produce an output in the following format depends on the ranking:
Mr. Doe usually responds to but only sometimes uses pronounces correctly and never uses advanced propositions.

Any ideas? thanks so much.

 

[FDibbins]

Hi, welcome to the forum

I think you need to provide some sample data, and show what you expect