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

Find from Random numbers

makeitpossibe

New Member
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
 
Dear Mr. Narayan
Sorry, for delay in my reply
I have uploaded file to understand more in details
I just knows excel basics.

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
 

Attachments

  • Yoga activites casi yatra for formula to find.docx
    12.5 KB · Views: 3
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
 

Attachments

  • yoga activities.xlsx
    16 KB · Views: 3
Last edited:
Back
Top