Quick access

FIFO calculation with Excel Data Table

FIFO calculation with Excel Data Table(Inventory ID is selectable in this sample) Table C6:E15 keeps inventory inward data for all inventory id ordered by its occurrance.Cell H2 is total unit sold of inventory id that selected in cell H3.Table F6:F15 calculates number of unit sol