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.

Fill up and down and then count results

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)