Urgent Question help!!

[dennisli828]

So please watch this tutorial first

http://www.youtube.com/watch?v=R5ZWAiNJLNo&feature=channel_video_title,

instead of using =IF(ROWS(D$2:D2)<=$C$2,INDEX($A$2:$A$10,SMALL(IF(ISNUMBER($A$2:$A$10),ROW($A$2:$A$10)-ROW($A$2)+1),ROWS(D$2:D2))),"")

Can we use formula: =IF(ROWS($D2:D2)<=$C$2,SMALL(I*F(ISNUMBER($A$2:$A$10),$A$2:$A*$10),$D2:D2+1),"")

for this purpose?? since SMALL(IF() ) will return the value directly, why bother using the index function?? please let me know

 

[GlennUK]

For those of us that cannot view that tutorial, how about explaining in detail what it is that you are talking about?