• 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...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.
N
Reaction score
865

Profile posts Latest activity Postings About

  • Hi Nebu -
    I kind of ran into a wall when trying to copy the same formula for the team winners.
    On the attached file - on Column A82-A85 of the tab "Sparks-Winner" please advise why the formula is not picking up Team Green even though it has the same score as Team Blue?
    My apologies for repeated posts on this topic but hopefully this will be my last request for this thread.
    N
    Nebu
    Hi:

    There is no sheet attached.

    Thanks
    Nebu
    Hi Nebu,

    Let me just explain this way then:
    =SUMIFS("'"&Reference&"'"!A:A,"'"&Reference&"'"!B:B,A20,"'"&Reference&"'"!C:C,Reference)

    Reference is a "Name" changes in real time based on a List selection. I get an error in this. Any help is appreciated.

    Regards,
    Chine
    N
    Nebu
    Hi:

    Sorry, I was sick and out. The indirect function will achieve what you are looking for. If you need the formula to be constructed by me just inbox me a sample file.

    Thanks
    N
    Nebu
    Hi:

    I do not have time to go through your entire assignment. I would suggest you to start with Forecast or trend formula in excel to predict for the future years.

    Thanks
    S
    Simayan
    How to club the 2 data sets...i.e. first & third sheet. Unable to do that. Can you help in arranging the data set..
    N
    Nebu
    I guess date is the common field for all the data set try to combine the data using the date field.
    Hi Nebu pls tell me if i can donate to you?
    N
    Nebu
    Hi:

    Thanks for that, I do not want any donations. I am working full time and I do this during my free time in office all is good. Thanks again for the thought. Only thing appreciation I look forward for is the learning I can get and the likes which the benefactor can give for the posts.

    Cheers
    Nebu
    M
    mhghg
    Thanks again Nebu, You again prove to me there still have a lot of good hearts in our world. I feel very good when I am in this forum.
    N
  • Loading…
  • Loading…
  • Loading…
Top