Excel: Vertical Criteria Not Available

Last reviewed: November 29, 1994
Article ID: Q47264

SUMMARY

The criteria range in a Microsoft Excel worksheet must be aligned horizontally across the page. The first row should contain the field name(s) from the database, and the second row should contain the data that is being set as criteria for selecting records from the database.

For example, if cell A1 contains the field name "Name", cell A2 should contain the actual name that is being used for the criteria.

REFERENCES

For more information, see "Setting Up a Criteria Range" on pages 330-331 of the "Microsoft Excel User's Guide 1," version 4.0. If you are using version 3.0, see pages 371-373 of the "Microsoft Excel User's Guide" version 3.0 manual. If you are using Excel 2.20, see pages 166-168 of the "Microsoft Excel Reference" version 2.2 manual.

KBCategory: kbother
KBSubcategory:
Additional reference words: 2.20 3.00 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.