Hi All
Im not sure if im making a mistake or i have confused Excel.
Im making a very SIMPLE inventory table for my workshop.
In a nutsell - its as easy as:
1. Item 2. In/Out 3. Current stock on hand(Calc) 4. Add or subtract stock
Logic is a follows:
I have a table. Items are a drop down list
The formula i have - which works without issue until excel crashes it - is to simply look at the rows above - to find the last entry of this items above,
which is the same as the second last entry of this item in the whole column array.
Formula works great. No circular reference nonsense.
Then - when i index this formula - to pull the value of the current quantity - it also starts ok, then crashes (says circular reference but cant identify it)
Please help ?
Bookmarks