• 43 Posts
  • 731 Comments
Joined 2 years ago
cake
Cake day: December 12th, 2023

help-circle








  • A little more complex.

    So say I have John, Jane, Max, and Susan. John has $25 and lives in Seattle. Jane needs $50 and lives in New York City. Max has $100 and lives in New York City. Susan needs $25 and lives in Seattle.

    I would match John with Susan and Jane with Max, right?

    Is there a way to get the spreadsheet to tell me that?

    And then if I were to add Jim who has $30 and lives in Seattle, can I get the spreadsheet to match both Jim and John to Susan?

    Conditional formatting might work at this scale, but what if I had 50 people and also added additional criteria? So instead of just budget and city, maybe there’s a store name. Maybe they only match 2/3 of the criteria.

    What would I do?

    🤔🤔