Hi,
I have two questions, unfortunately I’m not able to figure out how to do that,
I have two tables, Matches and Bets:
In Matches are following columns: match_id, name1, name2, winner
In Bets are are following columns: bet_id, match_id, username, bet
I created virtual columns in Bets IN([Bet],Matches[Winner]), unfortunately in case the winner is in the Matches more than once it will get wrong results.
Thank you in advance
Solved! Go to Solution.
Hi Marc,
thank you, dropdown from valid_if helped me with second question.
Unfortunately I have still issue with the first one.
Edit: I solved it with lookup function.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |