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.

Find from Random numbers

Discussion in 'Ask an Excel Question' started by makeitpossibe, Jun 17, 2017.

  1. makeitpossibe

    makeitpossibe New Member

    Messages:
    4
    Hello,

    Dear Friends and Excel experts.

    I need some help to make an easy formula on excel.

    It`s Yoga class activities Students are very in each class highest are 80 in one class.

    Excel example has been attached.

    (Note: Row- A,F,G,H– don’t worry about these rows. They are just for understandings. The main

    Rows are- B-C-D and Rows J-K-L where I need your help)

    Row A – Students name

    Row B- Roll number of those students which is (predefined)

    Row C- Name OR Number of Yoga Asana activities (Example multi asana Mayurasan number given 1, Vajrasan number given 2)

    Row D- Yoga Activities Performance Result (Manual Feeding -Result)

    Row number F-G-H (just for understanding in details)

    Row J-K-L here I need an answer need your help- formula

    This is every third or fifth days work

    So, What I need is

    Once I finished creating a Rows for Yoga Asana Activities (D), Roll number (E) and

    Manual result feeding (F)

    I want to find an answer look from Row B-C-D and give answer / result in Row J-K-L

    Once I type/write any number in Row-J & K it will find an answer for Row-L

    Row Number J and K will look/find in to Row B-C & D and give an answer result for Row-L

    I need some simple and easy formula. So, incase if I have to do any changes or correction I can do it easily.

    Thank you.

    YOGA activites RESULT.JPG
  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,579
    Hi ,

    Please upload your workbook.

    Narayan
  3. makeitpossibe

    makeitpossibe New Member

    Messages:
    4
    Dear Mr. Narayan
    Sorry, for delay in my reply
    I have uploaded file to understand more in details
    I just knows excel basics.

    Attached Files:

  4. makeitpossibe

    makeitpossibe New Member

    Messages:
    4
    Again Sorry I accept I made a one big mistake in my question
    Instead of Column every time I have wrote a Row ( so, please when you refer again to my question please read a Column instead of Row.

    Corrected uploading again

    Attached Files:

  5. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,579
    Hi ,

    I am sorry but I will take a day or two to reply.

    Narayan
  6. makeitpossibe

    makeitpossibe New Member

    Messages:
    4
    It's ok no problem.

    Thanks
  7. bosco_yip

    bosco_yip Well-Known Member

    Messages:
    1,247
    Maybe......

    In I3, copy to M3 and :

    =IFERROR(1/(1/SUMIFS($D:$D,$B:$B,G3,$C:$C,H3)),SUMIFS($D:$D,$B:$B,H3,$C:$C,G3))

    All copy down

    Regards
    Bosco

    Attached Files:

    Last edited: Jun 19, 2017

Share This Page