Excel 2007 : *SOLVED* How to group and sort data?

Hi guys,
I really need some help with a complex problem i am having.

I have been given about 90,000 rows of data.
Split into modules, and the modules are in chassis'.

Now.
Some of the modules have reached their termination date, others haven't.
What i need to do is find out which chassis' have no modules in them that have reached their termination date? If the chassis has one module that has reached its termination date then the whole chassis has to be classed as past its termination date.

I have tried sorting and filtering but i split up the chassis' if i do this and then I don't know if the chassis has just one module that is past its termination date?

If it helps module cells that have reached their termination date have a coloured background. If not they are white.

Any help to this very complex problem would be so greatful.

Many Thanks.