Excel Formula for Idle stock inventory report

JLYN

New Member
Joined
Feb 15, 2020
Messages
2
Office Version
2019, 2016, 2010, 2007
Platform
Windows, Mobile
Hi, Can someone enlightened me on how to create an Idle stock inventory report.
I need formulas where I can filter the outlets/branches whose stock inventory isnt moving number of weeks.
Im in sales dept. my boss wants to see the store where stock are not solde for 2 weeks, 4 weeks , 8 weeks.
I really need to finish this by monday.
Thank yoy for the kind soul who is going to answer
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,099
Office Version
2019
Platform
Windows
What does your current spreadsheet look like? How can we help you if you don't provide an example of your data file?
 

JLYN

New Member
Joined
Feb 15, 2020
Messages
2
Office Version
2019, 2016, 2010, 2007
Platform
Windows, Mobile
What does your current spreadsheet look like? How can we help you if you don't provide an example of your data file?
it looks like this.
I need to filter the zeros on the offtake column weekly.
It is like a monitoring of what outlet has a zero offtake for 2 weeks, 4 weeks and so on.
Screenshot_2020-02-15-22-20-00-93.png
 

Forum statistics

Threads
1,085,783
Messages
5,385,845
Members
401,974
Latest member
meantis

Some videos you may like

This Week's Hot Topics

Top