View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 236
Default Analyzing data in collections of classes?

Ker writes: "Once I have my data loaded from my worksheet into the
objects, my analysis
will be to look for specific patterns; What was the total amount of
vanilla
ice cream purchased from Brand_C as compared to vanilla ice cream
purchased
from Brand_X, excluding purchases where Brand_X was purchased in the
same
transaction as any items from Brand_Z? "

Don't load the data into the worksheet. If it's not loaded into a
database already, load it into a database. Let the database handle the
queries like this one.