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
<tbody>
</tbody>
Thank-you for your time, assistance and brilliant ideas!
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
A | B | C | D | E | F | G | H | |
1 | Ref | 20160801 | 20160718 | 20160701 | 20160615 | 20160601 | 20160517 | 20160401 |
2 | 1 | 2004-08-06 | 2004-08-06 | 2004-08-06 | 2004-08-06 | 2004-08-06 | 2004-08-06 | 2004-08-06 |
3 | 8 | - | 2007-03-18 | 2007-03-18 | 2007-03-18 | 2007-03-18 | 2007-03-18 | 2007-03-18 |
4 | 64 | - | - | 2016-05-25 | 2016-05-25 | 2016-05-25 | - | 2014-09-04 |
5 | 80 | - | - | - | 2016-02-13 | 2016-02-13 | 2016-02-13 | 2016-02-13 |
6 | 87 | 2016-05-06 | 2016-05-06 | 2016-05-06 | 2016-05-06 | 2016-05-06 | - | 2013-09-18 |
7 | 91 | 2016-07-11 | 2016-07-11 | - | - | - | - | - |
8 | 96 | 2006-01-20 | 2006-01-20 | 2006-01-20 | 2006-01-20 | 2006-01-20 | 2006-01-20 | 2006-01-20 |
9 | 101 | 2016-07-02 | 2016-07-02 | - | - | - | - | - |
<tbody>
</tbody>
Thank-you for your time, assistance and brilliant ideas!