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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,114,111
Messages
5,546,000
Members
410,720
Latest member
SSL
Top