Sort data using a formula and produce output by rank

[Bugy6999]

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

responds to questions <tbody> </tbody>	2
uses pronouns correctly <tbody> </tbody>	1
uses advanced propositions <tbody> </tbody>	0

<tbody>
</tbody>

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