Hello experts,
I am a beginner and played with Multi-Row formula but do not get the hang of what I want to do.
See example below (I made up a simple example):
STEP 1: I want to determine which of those PLAYERS actually played the GAME
STEP 2: I need to count the amount of GAME levels a PLAYER played
Would appreciate your help.
Solved! Go to Solution.
@pohrt
Hope this is what you need.
Whow that was fast .... Almost what I am after.....
I need to keep the Rows and not sum this up.
So I would like to see the final output like that ... (an in the original order of the Excel Sheet that I used as input)
Hope that makes sense ...???
Cheers,
Petra
That looks awesome!!!! I will update my "more complex" example using the sequence of steps.
Thanks... I learned a lot from this!!!
@pohrt
Glad to help and thank you for the accept mark. 😁