• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula

pripin8891

New Member
hello,


can anyone answer the link below?


http://www.fileconvoy.com/dfl.php?id=g08412badfabc72a9999284660a4e9083f1180fec5


thanks
 
Hi ,


Your requirement is not clear from your file ; can you explain whether you want the different values of code 101 to appear one after another ?


Your codes are in the range A2:A9 , while the values are in B2:B9 ; if you want these different values to appear in column G , then in G2 enter the following formula , as an array formula , using CTRL SHIFT ENTER :


=INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=$A$2,ROW($A$2:$A$9)-MIN(ROW($A$2:$A$9))+1),ROW(A1)))


Copy this down to G3 , G4 , G5 ,...


Narayan
 
hello,


thanks for ur response.

code 101H has values in B2,B4,B6,& B8 .

and i want to update these values in G3,G4,G6,G7 so that B2 value appear in G3,

B4 value appear in G4, B6 in G6 & B8 in G7.


i applied index & small if you have given but not working.


thanks
 
Hi ,


Sorry , I had not understood your requirement ; try this :


=INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=F2,ROW($A$2:$A$9)-MIN(ROW($A$2:$A$9))+1),COUNTIF($F$2:F2,F2)))


Enter it as an array formula in G2 ( using CTRL SHIFT ENTER ) , and copy downwards.


BTW , you have more 101 codes in column F than you have in column A.


Narayan
 
Back
Top