Date calculation with Zero *help desperately needed*

christat13

New Member
Joined
Aug 1, 2016
Messages
4
Hello,

Second time around trying to post this so if I've missed a detail please let me know.

I was trying to use a max/min function to create a tiered if statement but am not having any luck. I'm open to any ideas and suggestions

I am trying to determine whether inventory has been added, sold or relisted based on dates. Some of the cells have zero in them.
Scenarios:

1. No change as all of the dates are the same across the board i.e. ref #1, 8
2. Inventory is sold as there are dates it was listed and then a zero i.e. ref #8, 80
3. Inventory is sold and then relisted as in Ref #64, 87
4. Inventory is added as in Ref #7, 101

ABCDEFGH
1Ref20160801201607182016070120160615201606012016051720160401
212004-08-062004-08-062004-08-062004-08-062004-08-062004-08-062004-08-06
38-2007-03-182007-03-182007-03-182007-03-182007-03-182007-03-18
464--2016-05-252016-05-252016-05-25-2014-09-04
580---2016-02-132016-02-132016-02-132016-02-13
6872016-05-062016-05-062016-05-062016-05-062016-05-06-2013-09-18
7912016-07-112016-07-11-----
8962006-01-202006-01-202006-01-202006-01-202006-01-202006-01-202006-01-20
91012016-07-022016-07-02-----

<tbody>
</tbody>


Thank-you for your time, assistance and brilliant ideas!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
what are the dates in the very top row

the dates are split on 2 rows or is the 06 in ref 1 something else

give us one row and explain how inventory levels change

for me it is very unclear at the moment
 

christat13

New Member
Joined
Aug 1, 2016
Messages
4
Hi the dates at the top row are the report dates i.e. newest report is in Column B, followed by Column C...

Dates are only split in the rows due to the width of the table but not in reality
 

christat13

New Member
Joined
Aug 1, 2016
Messages
4
Sorry to answer your question on one row:

Row #4, ref #64: Inventory was listed on 2014-09-04 and was sold (you can see the zero in the 20160517) and then relisted on 2016-05-25 (as shown on the 20160601 inventory report) and then later resold as it is not on the 20160718 inventory.

Second example row 7, item #91 - all zeros from the inventory reports until 20160708 followed by a date in 20160718 reflecting that inventory was added

finally, example row 3, item #8 - all dates from inventory reports to 20160718 followed by a zero on 20160801 reflecting that it was sold.

Hope that makes it clearer but if not, please let me know and I'll try to add clarification.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,756
Messages
5,524,677
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top