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. ### makeitpossibeNew 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)

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.

Messages:
15,112
Hi ,

Narayan
3. ### makeitpossibeNew 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.

File size:
15 KB
Views:
3
4. ### makeitpossibeNew Member

Messages:
4
Again Sorry I accept I made a one big mistake in my question

File size:
12.5 KB
Views:
3
5. ### NARAYANK991Excel Ninja

Messages:
15,112
Hi ,

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

Narayan
6. ### makeitpossibeNew Member

Messages:
4
It's ok no problem.

Thanks
7. ### bosco_yipWell-Known Member

Messages:
1,168
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:

• ###### yoga activities.xlsx
File size:
16 KB
Views:
3
Last edited: Jun 19, 2017