extract multiple itmes with one lookup value

[Rahul Mishra]

Dear Sir,

may be I have asked this question but now I am missing some point please help me this matter.

and how can I see all answer and question which I asked to you I am unable to see please provide me solution of this also.

 

[mohadin]

Hi
please find the attached
Hope it's what you need

 

[Rahul Mishra]

sir thank you so much
but one thing I could not understand why we are using in this small function

 

[mohadin]

hi
so sorry I could not understand " using in this small function"
what do you mean
maybe you mean the curly brackets?
If so cause the formula is array formula you have to c&s&enter

 

[Rahul Mishra]

NO I want how work these formula in this function
like small function row function and column function.

 

[mohadin]

hi
=row() gives you the actual row number
row(a1) gives you the row number of cell a1 witch is 2 & 2 for a2 ....
=column (a1) gives you the number of column a witch is 1 & 2 for column b ....

small is dealing with array say b1:b5 for example( small(b1:b5;1) gives you the first smallest value in the arry & small(b1:b5;2) gives you the 2ed smallest value tn that array
hope this helps
by the way you can find explnation in excel help as a start
regards