1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need the specific values from a table

Discussion in 'Ask an Excel Question' started by JAlandhar 201718, Oct 6, 2018.

  1. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    68
    Hello Everyone,

    This is Anshum this side, and I need help as I need specific values from a table, which is updated with hourly basis with new entries, I just need specific values in return as "the amount in the table>0" . Please help me with the formula that i can update my sheet for better result.

    Attached Files:

  2. salim hasan

    salim hasan New Member

    Messages:
    15
    Try this file
    Array Formula in G10 ====>(control+Shift+Enter)
    Code (vb):

    =IF(ROWS(G$10:G10)>COUNTIF($D$8:$D$100,">0"),"",INDEX(A$8:A$100,SMALL(IF($D$8:$D$100<>"",IF($D$8:$D$100>0,ROW($A$8:$A$100)-ROW($A$8)+1)),ROWS(G$10:G10))))
     
    JAlandhar 201718 likes this.
  3. pecoflyer

    pecoflyer Active Member

    Messages:
    236
    Last edited: Oct 7, 2018
  4. vletm

    vletm Excel Ninja

    Messages:
    4,152
    JAlandhar 201718
    ... or with Advanced Filter
    1) Create Criteria to G4:G5
    2) Select List Range
    3) Select Advanced Filter
    4) Modify Parameters as below
    5) Press [OK]
    Screen Shot 2018-10-07 at 11.20.28.png
    sathishsusa likes this.
  5. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    68
    should I follow the same formula for all the columns & rows, to get the proper result
  6. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    68
    thankyou for your reply Sir,

    but I need auto filter whenever the data is updated, by your way i have to do it manually
  7. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    68
  8. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    68
    hello sir, can you please help me in this formula too, as i need the different amount from the table, but it shows the same amount as of previous in last line of result, Help me please

    Attached Files:

Share This Page