Grouping Projects Formula

[rwcg2d]

Hello, I have two columns:

Project - Include

I want to group all of the different projects based on the order they appear/are marked included (1,2,3,n).

How would I do this?

Example:

Project1	X	1
Project1	-	-
Project1	X	1
Project2	-	-
Project3	x	2
Project3	x	2

<tbody>
</tbody>

 

[James006]

Hello,

Once the formula you are looking for is applied to your example ...

What would your expected result look like ...?

 

[rwcg2d]

The expected result is the third column listed.