2
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 30 Oct 2025
2 points (100.0% liked)
Spreadsheets
54 readers
1 users here now
founded 2 years ago
MODERATORS
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?
🤔🤔
Wow. Thanks for the example. That's kinda crazy and asking way beyond what a spreadsheet's formulas could typically do. You're basically asking to write an algorithm. I don't know if I'd even have the expertise to write an optimal script in !ahk@programming.dev, but I could try. But I do believe that you're posting this question in the wrong community.
Thanks! You're right aha. Appreciate it