How to use Microsoft Excel data tables to analyze information in a database

Comparison criteria are the most commonly used criteria to extract or analyze information from a Microsoft Excel database. The value that you place under the column heading in your criteria range is compared against the records in your database. If a record matches that value, the record is extracted or included in the group of records to be analyzed by the database functions.

http://support.microsoft.com/kb/282851/en-us

Suresh Behera

No Comments