Keep track of my inventory

LStrike

New Member
Joined
Oct 15, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
In the example i have added in the sheet i have Date out. The date my product has been sendt to cleaning
And article name.
and personal user id
Date inn. retuned after 7 days

In need a formula that can count how many items of each art. i need for each user.
Items are peronalized. so they cant use items from other users (even if its the same art.)
if the item is not returned from cleaning before they need another one i need to have ekstra in stock.
So need to know ho many need in stock at any given time.
in my original sheet i have 400 users with different usage. its to hard to calculate this manualy

I have tried diffrent variation of count function but cant find a way to reduce stock when its delivered.

If anyone could help me with this it would be nice.
 

Attachments

  • screenshot.JPG
    screenshot.JPG
    136.2 KB · Views: 14

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,114,665
Messages
5,549,305
Members
410,908
Latest member
Allen P
Top