Microsoft KB Archive/28866

Excel: Selecting All but the First Row in a Range (Database) PSS ID Number: Q28866 Article last modified on 05-03-1991 PSS database name: M_eXceL

1.00 1.03 1.04 1.06 1.50 2.20 3.00

MACINTOSH

Summary:

In a Microsoft Excel macro, to select a range that excludes the first row of that range, use the following formula:

=SELECT(OFFSET(!range,1,0,ROWS(!range)-1))

For example, to select all the records in a database without selecting the field names, use the following formula:

=SELECT(OFFSET(!Database,1,0,ROWS(!Database)-1))

This step is useful for sorting all the records in the database.

Copyright Microsoft Corporation 1991.