Results 1 to 15 of 15

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

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2011
    Location
    Reading, England
    MS-Off Ver
    Excel 2007
    Posts
    8

    *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.
    Last edited by joshrob; 09-20-2011 at 10:49 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1