gritch,
I seem to recall this type of request before, and that someone was able to come up with a "function". So, let's hope that expert is "listening" and will come through.
In the meantime, if you'd like, I can email you a model that you'll probably find useful. I developed it a short time ago for another Tek-Tips member.
The model provides some "basics" related to using VBA (attached to buttons) to:
a) extract UNIQUE records.
b) generate TOTALS for the number of these UNIQUE records - both a COUNT of the number of UNIQUE records, and a SUM of the Dollar Value (another field) related to the UNIQUE records.
c) sorting the extracted records.
There are also "notes" inserted into the file, and these notes deal with a couple "quirks" related to Excel's database functions - i.e. Data - Filter - Advanced Filter.
For example, when attempting to use Data - Filter - Advanced Filter to extract records to a SEPARATE sheet, Excel produces an ERROR message saying that it's NOT possible. This is a "bug" - as it IS possible using the same VBA code that one can record using Data - Filter - Advanced Filter.
Another ERROR message can be encountered that says you HAVE to keep your "criteria" on the SAME sheet as your database. NOT so - it IS possible to have the criteria on a SEPARATE sheet.
If you feel this file would be useful, just email me at my HOME address, and I'll send the file via return email.
As always, if ANYONE ELSE feels this file might be useful, please don't hesitate to ask for it.
Regards, ...Dale Watson
HOME: nd.watson@shaw.ca
WORK: dwatson@bsi.gov.mb.ca