Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Drop down multi-cell propogation

  1. #1
    New Member
    Join Date
    Apr 2017
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Drop down multi-cell propogation

    I'm trying to propagate multiple cells underneath a drop down on "another sheet", so when you choose a selection it places the list of numbers underneath it in the same format as it is in my table.

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    please show us a small example

  3. #3
    New Member
    Join Date
    Apr 2017
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    Rate Schedule: TOU-GS-2-B (drob down)
    Rates
    Winter Mid
    Winter Off
    Summer On
    Summer Mid
    Summer Off
    (Space)
    Non-time Demand
    Summer On Demand
    Summer Mid Demand
    Customer Charge

    (Rate Schedules)

    Rates TOU-GS-1-A TOU-GS-1-B TOU-GS-2-A
    Winter Mid 0.14251 0.10479 0.07173
    Winter Off 0.13357 0.07556 0.06157
    Summer On 0.20994 0.14733 0.33751
    Summer Mid 0.17197 0.07343 0.11185
    Summer Off 0.14671 0.05521 0.05502
    Column1
    Non-time Demand 9.74 15.48
    Summer On Demand 6.47
    Summer Mid Demand 2.46
    Customer Charge 24.77 24.77 220.3

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    so if you select winter mid there is no match for tou-gs-2-b ?

  5. #5
    New Member
    Join Date
    Apr 2017
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    Quote Originally Posted by oldbrewer View Post
    so if you select winter mid there is no match for tou-gs-2-b ?
    Negative.

  6. #6
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    the single word negative does not help us to help you....

  7. #7
    New Member
    Join Date
    Apr 2017
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    Quote Originally Posted by oldbrewer View Post
    the single word negative does not help us to help you....
    It does not, it displays NA.

  8. #8
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    post 5 just says negative. Where is the NA - or am I losing the plot ?

  9. #9
    New Member
    Join Date
    Apr 2017
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    Quote Originally Posted by oldbrewer View Post
    post 5 just says negative. Where is the NA - or am I losing the plot ?
    My fault, I tried:

    =INDEX(tbl_items[Winter Mid],MATCH(B1,tbl_items[itemnum],0))

    And got NA.

    See I forgot youre not a mind reader...



    Or are you?!?!?

  10. #10
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drop down multi-cell propogation

    try something where you know there will be a successful match for test purposes

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com