Excel no VBA - array problem

L

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
 
J

Jason Morin

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

HTH
Jason
Atlanta, GA
 
L

lynnas

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

thank you Jason,

Lynna
 
Top