+ Reply to Thread
Results 1 to 1 of 1

Single field fits fault category, event category determined by group of faults

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003, 2007

    Question Single field fits fault category, event category determined by group of faults


    Attached is a sample spreadsheet - sample07APR2010.xls - that contains data from 2 events in Sheet1. Each event may or may not be comprised of multiple faults. Each fault fits into a category on its own; however, if an event contains a certain group of faults (which may or may not be in the same individual fault category), the event category is something else. For example, the first event in the spreadsheet contains 30 individual faults of various individual fault categories. When pooled together, they make up a "Grid or power cycle" event.

    How can I best organize the fault reference data (FaultCategories sheet), grouping where necessary? The other challenge is coming up with a lookup formula that determines the faults associated with the event, then assigning an event category. Also note that the faults grouped to make up an event category may change. Plus, new event categories may be necessary in the future.

    Any help is greatly appreciated!

    Thanks in advance,

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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