I will probably have a couple thousand.

Josh

"T. Valko" wrote:

How many rows of data do you have? If you have 1000's of rows of data a
formula solution will be slow to calculate.

--
Biff
Microsoft Excel MVP


"jxbeeman" wrote in message
...
How do I Consolidate an array? Let me explain. I'm 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). I'm looking to do
something like a pivot table just with a formula. I know I can just do a
sort but for what I'm going to be using it for will be too manual to
repeat.
So I'm 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