pluginguin
New Member
- Joined
- Aug 10, 2016
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
Please check out my Excel Range.
The Array Formula should copy all ItemCodes from Sheet 1 to Sheet 2, where "Below Stocklevel" value = 1.
But somehow it's doesn't do anything. What am I missing?
This is the source table: (Sheet1)
And this is the result table (sheet2) with the array formula
I expect to see the values 300102 and 300143 but in stead I see nothing.
The Array Formula should copy all ItemCodes from Sheet 1 to Sheet 2, where "Below Stocklevel" value = 1.
But somehow it's doesn't do anything. What am I missing?
This is the source table: (Sheet1)
ItemCode | Below StockLevel |
1300011 | 0 |
130021 | 0 |
130022 | 0 |
130023 | 0 |
130024 | 0 |
130025 | 0 |
300031 | 0 |
300101 | 0 |
300102 | 1 |
300103 | 0 |
300104 | 0 |
300141 | 1 |
300142 | 0 |
300143 | 1 |
And this is the result table (sheet2) with the array formula
ItemCode |
{=IF.ERROR(INDEX(Sheet1!A$2:A$15;SMALL(IF(B$2:B$15=1;ROW(A$2:A$15));ROW(1:1))-1;1);"")} |
I expect to see the values 300102 and 300143 but in stead I see nothing.