Calculating Multiple Comparisons over Large Sample

[Pherion]

I have a sample of aproxomatly 30,000 records, and I am working to do some data analysis on it.

I am comparing multiple fields using sumproduct(), but if I go above two criteria, the calculation time becomes incredibly long. Is there a faster way to preform these large comparisons, or am I stuck watching my Excel lag out for 5 min every time I recalculate the sheet?

Thanks!

[NBVC]

Maybe with Helper columns to do basic comparisons and then count/sum those results? Or maybe Pivot Tables?

[Pherion]

Hey, thanks for the advice. I tried throwing together a pivot table for the information, but either I'm not using it right, or it cant display the information that I want.

The kinds of comparison's I'm trying to make are:

I have one field which is an age, anywhere from 15 to over 4000 days old for the particular item. I want to break this down into 30 day intervals, and display how many items are in each range. I then want to break it down even further, and say how many are in each range that meet a particular criteria.

Can a Pivot table do this?

[NBVC]

Can you supply a sample workbook? Showing intended results.

Make sure confidential info is left out or replaced

[Pherion]

Unfortunatly I can not upload anything. I did however narow my criteria on the initial sample, and the functions run much faster when the sample size is reduced. Fortunatley for me, the reduction in sample size actualy increased my accracy. Turns out some stuff was being sampled that wasn't suppose to be...

Thanks for the help!

[NBVC]

Great,

Could you please mark your thread as Solved to close it.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save