Excel no VBA - array problem

[lynnas]

Hello,

i've got three columns in my worksheet :

article | shop | quantity

i want to put into an array all the cells of column 'quantity' tha
correpond to a given article.

for article = '12012' in cell A1, i would have in B1 : {1;2;3;54;54}.

i put in B1
{=IF((article=A1)*quantity;quantity;"")}

but:
-it makes a big array almost completely empty
-when i want to use centils, i does not work anymore.

what should i do ?

thanks

Lynna

 

[Jason Morin]

What is it exactly you're trying to do? What end result
are you wanting?

HTH
Jason
Atlanta, GA

 

[lynnas]

i found the solution :
indirect (adress of the range of cells) !

thank you Jason,

Lynna