Hello,
I have a data, basically to count product availability per day. I want to put an alert or something like that on the first 2 column for example in column B, that if there's any of the product on any given day is less than 5 then it will list all the dates that are on low availability.
I tried to use Countif and If formula but it doesn't work as the availability column are alternate between sold column. Can anyone help me to find the best way to solve this please. Thanks
http://Excel 2016 (Windows) 32 bit
<tbody>
</tbody>
I want it to come have the alert as per below on column B3. something like that.
http://Excel 2016 (Windows) 32 bit
<tbody>
</tbody>
I have a data, basically to count product availability per day. I want to put an alert or something like that on the first 2 column for example in column B, that if there's any of the product on any given day is less than 5 then it will list all the dates that are on low availability.
I tried to use Countif and If formula but it doesn't work as the availability column are alternate between sold column. Can anyone help me to find the best way to solve this please. Thanks
http://Excel 2016 (Windows) 32 bit
B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|
4 | Products | 1/01/2020 | 2/01/2020 | 3/01/2020 | 4/01/2020 | 5/01/2020 | |||||
5 | Sold | Available | Sold | Available | Sold | Available | Sold | Available | Sold | Available | |
6 | Batteries | 25 | 25 | 30 | 20 | 22 | 28 | 48 | 2 | 46 | 4 |
7 | Pencils | 45 | 5 | 45 | 5 | 15 | 35 | 35 | 15 | 47 | 3 |
8 | Books | 10 | 30 | 10 | 30 | 10 | 30 | 15 | 25 | 20 | 20 |
9 | Calculators | 30 | 28 | 2 | 18 | 12 | 30 | 0 | 28 | 2 | |
10 | Pens | 5 | 45 | 50 | 15 | 35 | 50 | 50 |
<tbody>
</tbody>
I want it to come have the alert as per below on column B3. something like that.
http://Excel 2016 (Windows) 32 bit
B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|
3 | Alert!!! 02/01/2020,04/01/2020,05/01/2020 | ||||||||||
4 | Products | 1/01/2020 | 2/01/2020 | 3/01/2020 | 4/01/2020 | 5/01/2020 | |||||
5 | Sold | Available | Sold | Available | Sold | Available | Sold | Available | Sold | Available | |
6 | Batteries | 25 | 25 | 30 | 20 | 22 | 28 | 48 | 2 | 46 | 4 |
7 | Pencils | 45 | 5 | 45 | 5 | 15 | 35 | 35 | 15 | 47 | 3 |
8 | Books | 10 | 30 | 10 | 30 | 10 | 30 | 15 | 25 | 20 | 20 |
9 | Calculators | 30 | 28 | 2 | 18 | 12 | 30 | 0 | 28 | 2 | |
10 | Pens | 5 | 45 | 50 | 15 | 35 | 50 | 50 |
<tbody>
</tbody>
Last edited: