Hi
I want to dynamically expand my data as follows without using VBA.
I have text data in a single column. There is no empty cells in between the data but the number of rows having data can vary.
<tbody>
</tbody>
I want my result as follows.
<tbody>
</tbody>
If I add one more data:
<tbody>
</tbody>
I want my result updated automatically as follows.
<tbody>
</tbody>
Any help would be highly appreciated. But, again, only Formulas, NO VBA.
Thank you.
I want to dynamically expand my data as follows without using VBA.
I have text data in a single column. There is no empty cells in between the data but the number of rows having data can vary.
Names |
John |
Sam |
Jessica |
<tbody>
</tbody>
I want my result as follows.
Matches |
John Vs Sam |
John Vs Jessica |
Sam Vs Jessica |
<tbody>
</tbody>
If I add one more data:
Names |
John |
Sam |
Jessica |
Peter |
<tbody>
</tbody>
I want my result updated automatically as follows.
Matches |
John Vs Sam |
John Vs Jessica |
John Vs Peter |
Sam Vs Jessica |
Sam Vs Peter |
Jessica Vs Peter |
<tbody>
</tbody>
Any help would be highly appreciated. But, again, only Formulas, NO VBA.
Thank you.