Fill up and down and then count results

[pohrt]

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

• I was thinking this might be a good candidate for Multi-Row formula
• But the formula has to fill in the information based on 2 Columns (Player and game Status)
• The formula also has to fill in UP and DOWN
• If a player has played and level the RESULT should be "PLAYED" 
• (hope this makes sense)

STEP 2: I need to count the amount of GAME levels a PLAYER played

• I want to count the amount of games an individual  player played

Would appreciate your help.

[Qiu]

@pohrt 
Hope this is what you need.

[pohrt]

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

[Qiu · Accepted solution]

@pohrt 
Sorry about that.

How about this one.

[pohrt]

That looks awesome!!!! I will update my "more complex" example using the sequence of steps.

Thanks... I learned a lot from this!!!

[Qiu]

@pohrt 
Glad to help and thank you for the accept mark. 😁