Quote Originally Posted by LalitPandey87 View Post
Formula will look like this:

Code:
=IF(ROWS(A$26:A26)<=COUNTA(A$3:A$23),INDEX(A$3:A$23,SMALL(IF(LEN(A$3:A$23),ROW(A$3:A$23)-ROW(A$3)+1),ROWS(A$26:A26))),"")
That's intentional. I guess the OP is using European version of Office.