Forum Discussion
Count if
I have attached a sample document (names changed) Row 3-5 is Abbies activity- I want to have a formula which will work for 100's of names (I have just pulled 3- to show you what it looks like) ...
OliverScheurich this seems the best way to solve my problem. How do you create the green table that you have done above?
In the Power Query Editor you can follow the steps that created the result. The steps are indicated in yellow on the right in the screenshot. "Angewandte Schritte" means applied steps. In addition you can click on a gear icon (indicated in blue) and view the applied transformation. In the attached file i've translated the description of the steps.