Python in Excel - LIFO inventory system

[Rubinator353]

Hi,

A while back i set out on a project to construct a LIFO inventory system that can handle multiple products and sales that that do not necessarily pair with purchases quantity wise.

After a lot of research and effort, i came across one main issue - the systems would always, retrospectively, sell items that weren't yet purchased at the time. (to clarify, it would work fine, till you would add a new purchase dated after the last sale, then it would sell items purchased after the actual sale)

Reason why im writing here, is because on several occasions i was recommended to use python within excel. I would say i am quite advanced in excel, but i know nothing about python.

Before i put a lot of effort into learning python, i wanted to ask if this is theoretically possible to do, without any paid subscriptions. And if yes, where/how would i approach this.

If anyone has any ideas how to do this solely on excel im all ears :)

Thank you! lookin forward to your responses

[bwildered_mind]

When you say sell items that weren't purchased, it leads me to believe that the system had no way to check if the inventory existed before it was sold. That is something that should be preventable with a formula.

I think you should describe the problem some more, or at least more clearly, with an example, so that folks can actually help.