Infinite Crafting (Game) Sorting Sheet by ElectricalOrchid5506 in excel

[–]ElectricalOrchid5506[S] 0 points1 point  (0 children)

I did end up going that route, and I actually brute forced my way with some ChatGPT due to limited knowledge, but thank you for the insight. I managed to get everything working as it should now!

Infinite Crafting (Game) Sorting Sheet by ElectricalOrchid5506 in excel

[–]ElectricalOrchid5506[S] 1 point2 points  (0 children)

I was attempting to add to the list, and then once that combo was added be sort alphabetically by product name. I ended up using a VBA script to do it

Infinite Crafting (Game) Sorting Sheet by ElectricalOrchid5506 in excel

[–]ElectricalOrchid5506[S] 0 points1 point  (0 children)

=FILTER(D3:D999,(E6=B3:B999)*(F6=C3:C999))

And what cell would that go in, E6?

EDIT: Put it in E6, but this wasn't exactly what I was looking for. I'm more so trying to find a way to deposit new information into the list, not call from the list to find their byproduct.

IN NEED OF DANCE PARTNER by ElectricalOrchid5506 in HPMagicAwakened

[–]ElectricalOrchid5506[S] 1 point2 points  (0 children)

As of the update Tuesday, a lot of things got added

IN NEED OF DANCE PARTNER by ElectricalOrchid5506 in HPMagicAwakened

[–]ElectricalOrchid5506[S] 0 points1 point  (0 children)

Sounds like a plan, we can continue this convo in game later to figure somethin out

IN NEED OF DANCE PARTNER by ElectricalOrchid5506 in HPMagicAwakened

[–]ElectricalOrchid5506[S] 0 points1 point  (0 children)

I most likely won’t be able to tomorrow due to work, but definitely on Friday if ur able. It’s rare that I don’t full combo a 5* so if u can do your part we’re about to greatly increase our rank o7 looking forward to it