I need a formula in column D that will give everyone their marble allocation based on how many they want, and their score.
Column A: Users Name Column B: How many marbles each person wants in a perfect scenario Column C: Their score or ranking within the group (higher score gets more) Column D...