When extracting data in a large spreedsheet using the filter? Do the output shows one record at a time or does it shows all the records that meets the criteria. Some one told me that you can use excel as a flat data base is this true? If it is true how do you go about setting up a spredsheet to do this.

Thanks
Doctor z