+ Reply to Thread
Results 1 to 2 of 2

Finding Applied Transmission Clutches in "What's On When" Chart?

  1. #1
    Forum Contributor
    Join Date
    Grass Lake, Michigan
    MS-Off Ver
    Excel 2007

    Finding Applied Transmission Clutches in "What's On When" Chart?

    OK, this sounds like a simple problem, but it is giving me a headache! I have a "what's on when" table for a 9-speed transmission, showing which clutches (labeled A, B, C, D, E, and F) are applied in each gear. For a shift between any two particular gears, user enters the starting gear (FromGear) and the ending gear (ToGear), and I need to populate a table that shows which clutches are applied in each of those two gears.

    See the attached file.

    Note that there are always three (3), and ONLY three, clutches applied in any gear. For most shifts, two clutches will remain applied (in both the FromGear and ToGear), while the other applied clutch will change. Although there could theoretically be two (or all three) clutches that change state during the shift. The first part of the table (that finds the applied clutches in FromGear, cells D19:D21) is pretty simple and works fine. For the applied clutches in ToGear (cells E19:E21), it is easy to check whether the clutch that was applied in FromGear (column D) is still applied (and if so, display that same clutch letter). But I am having a hard time when the clutch in column D is no longer applied in ToGear ("Help!" in the existing formulas). I have tried to use an array formula, but not having any luck.

    Note that, although the "FromGear" clutches will always be listed in ascending order alphabetically, this is not the case for the "ToGear" clutches (which is part of the problem!). For example, in the attached file (using a 7-4 shift), clutches A, E, and F are applied in ToGear (4th). But cell E20 should NOT show clutch E (because it will be shown in row 21 as "still applied"). Cell E20 should show clutch F. So the formula that replaces "Help!" should find the first (or next) clutch that IS applied in ToGear AND was NOT applied in FromGear.

    I appreciate any help! Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    Washington, DC
    MS-Off Ver

    Re: Finding Applied Transmission Clutches in "What's On When" Chart?

    Not sure I'm interpreting the problem correctly, but it seems you want to find the first clutch that occurs when the FromGear does not have an X, and the ToGear does have an X. For the current setup in your example file, this looks like Clutch F would be the answer, since it is the only clutch to meet the previously stated conditions. If this is correct, you can try this formula, entered as an array with CTRL+SHIFT+ENTER, into E20:

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 11-10-2020, 01:55 PM
  2. Replies: 8
    Last Post: 07-12-2017, 05:32 PM
  3. templates can't be applied to PivotCharts with multiple "axis (category)" fields
    By 58906341589615896 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-30-2014, 07:50 AM
  4. Replies: 12
    Last Post: 06-12-2014, 02:11 PM
  5. [SOLVED] Resolve message "No more fonts may be applied to this work book"
    By dwighhtmv700 in forum Excel General
    Replies: 1
    Last Post: 05-10-2006, 08:50 PM
  6. [SOLVED] Explanation for Excel message "no more fonts may be applied"?
    By Ralph Coomber in forum Excel General
    Replies: 2
    Last Post: 05-05-2005, 08:06 AM


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