Hi there ,
Any body can help me understand how to extract a small range from a big amount of data based on the value of one cell using index function and small function
here is the function but i don't understand it ... please help me to apply it ...
=INDEX(B2:C14,SMALL(IF(B2:B14="match",ROW(B2:B14)-ROW(B2)+1,ROW(B14)+1),"row_item"),"col_index")
Bookmarks