HOW TO RIGHT A FORMULA TO HAVE NUMBERS APPEAR IN ORDER
 

HOW TO RIGHT A FORMULA TO HAVE NUMBERS APPEAR IN ORDER SEQUENCE

HOW TO RIGHT A FORMULA TO HAVE NUMBERS APPEAR IN ORDER
 

B1: =small($A$1:$A$20,row())
C1: =Large($A$1:$A$20,row())

Select B1:C1 and drag fill down the column.

--
Regards,
Tom Ogilvy


"ANEKA" wrote in message
...
HOW TO RIGHT A FORMULA TO HAVE NUMBERS APPEAR IN ORDER SEQUENCE