Inventory Control

[Janke]

I have to create a speadsheet that tells me how much of 1 item was used by spesific members using the following information
Column A (item bin nr)
Column B (description)
Column C (member)
Column D (quantity of item used in 1 of many orders)
Colunm E - H (dates and internal order nrs)
What formula would be appropriate?

 

[Oeldere]

I advice you to take a look at pivot table.