After entering the formula, double click the fill handle in the bottom right hand corner of the cell. Excel will attempt to copy the formula down as far as any adjacent cells. John Green, Sydney Australia (Tue, 28 Jul 1998 15:04:42 +1000) Q152383 XL: How to Run a Sort When a Calculation Occurs, Last reviewed: January 7, 1998 Brought to our attention by Tom Ogilvy (Tue, 28 Jul 1998 08:42:01 -0400)