Worksheet FormulasCell 
Formula 
H1 
=ADDRESS(ROW(H3),COLUMN())&":"&ADDRESS(ROW(H3)+COUNTIF(H3:H43,"> ")1,COLUMN()) 
I1 
=ADDRESS(ROW(I3),COLUMN())&":"&ADDRESS(ROW(I3)+COUNTIF(I3:I43,"> ")1,COLUMN()) 
N1 
=ADDRESS(ROW(N3),COLUMN())&":"&ADDRESS(ROW(N3)+COUNTIF(N3:N43,"> ")1,COLUMN()) 
E3 
=COUNTIF($C3:$C$20,C3) 
F3 
=A3&C3 
G3 
=IF(C3=K$3,COUNTIF($F3:$F$20,A3&C3),"") 
H3 
=IF(COUNTIF(E:E,1) < ROWS(H$2:H2),"",INDEX(C$3:C$20,AGGREGATE(15,6,ROW(E$3:E$20)ROW(H$2)/(E$3:E$20=1),ROWS(H$2:H2)))) 
I3 
=IF(COUNTIF(G:G,1) < ROWS(I$2:I2),"",INDEX(A$3:A$20,AGGREGATE(15,6,ROW(F$3:F$20)ROW(I$2)/(G$3:G$20=1),ROWS(I$2:I2)))) 
E4 
=COUNTIF($C4:$C$20,C4) 
F4 
=A4&C4 
G4 
=IF(C4=K$3,COUNTIF($F4:$F$20,A4&C4),"") 
H4 
=IF(COUNTIF(E:E,1) < ROWS(H$2:H3),"",INDEX(C$3:C$20,AGGREGATE(15,6,ROW(E$3:E$20)ROW(H$2)/(E$3:E$20=1),ROWS(H$2:H3)))) 
I4 
=IF(COUNTIF(G:G,1) < ROWS(I$2:I3),"",INDEX(A$3:A$20,AGGREGATE(15,6,ROW(F$3:F$20)ROW(I$2)/(G$3:G$20=1),ROWS(I$2:I3)))) 

Like this thread? Share it with others