How do I Consolidate an array? Let me explain. Im trying to consolidate an
array based on a single column. So I have say 3 columns with data, (P/N,
Desc, In-stock) (In-stock has a value of either 1 or 0). How would I pull an
array or list with only the ones in stock (value of 1). Im looking to do
something like a pivot table just with a formula. I know I can just do a
sort but for what Im going to be using it for will be too manual to repeat.
So Im looking for a formula that will pull the next value(P/N) out that has
a value of 1 in the in-stock column.
Ex.
P/N Desc In-Stock
1 "--" 1
2 "--" 0
3 "--" 0
4 "--" 1
5 "--" 1
Result i'm looking for (on another sheet)
P/N
1
4
5

Thanks in advance,
Josh