I was seeking for the fail and pass in one subject problem from within the month. But now i knew it. Thank you very much for this video. Lots of love.

@evelinalumato9052

2 жыл бұрын

Where did he get 35 in pass or fail

I really love the way that you explain.

mai kisi ki bhi video pr comment bahut bahut hi rare hi chance h ki kru but sir You are brilliant Thank you so much Your Teaching Skill is osm🔥🔥I Salute you sir🔥

Thank you very much! My project worked.. Wonderful video!

That's a great tuition. Thanks so much.

Very informative thank you for teaching us

Thanks it's really very helpful I love this video

Hello sir, it's a helpful video. I'm need one help. What would be the formula to find the total marks for English plus best four subjects. There are total of six subjects. Your help would be highly appreciated. Thank you!

Thanks, it's really helpful

More grace ur the best teacher 🙏🏻🙏🏻❤️

Great really fruitfull tutorial

tq sir I'm using this process superb clarity

It is a very good way of teaching and I understand each and everything thank you so much

Wonderful.. 🙏 Thank You

A failed student is getting higher rank than who passed also status of failed students is good Still required improvement in formula application

the best teacher I ever found .you mastered it!!

Thank you so much for this video .😊

The video is very excellent. I like to much

you are great sir . it was really very helpful video specially for me

Good explanation thanks 👍

Thank you brother....🎉🎉🎉 Now I can understand very well

Sir,the total range will be given in the question or we need to assume it as i2 and i11

You are the best teacher i forgot the IF function but you remembered me thanks

Last words knocked me out "So this is how simple it is, thank you" 🤣

millions of thanks to you sir for this video.. May God bless you more with knowledge to share..

thank you very much sir, it is more useful for me. I am thankful to you sir.

thank you sir, well explanation

How easily you explained thank you sir

Thank-you the video is very helful

Very very helpful 👍☺️

Thank you so much for this sir.

Really super sir very useful to us

It was really helpful

Thank you so much sir it is so helpful

How do I send the answers and scored points (not points allocated to the questions) of my students' marked exam papers? They did not type the email address on the exam Google form.

You are the best,so simple and well detailed❤❤❤

Simply superb

Thanks for the video, at 9:01, you mentioned poor, shouldn't you have used if statement for less than 50 too? Just asking for clarification. 🙏

Thank you so much sir

Thanks for video.

Thank you sir!!

Why did you allocate rank for failures? Can you calculate ranks in serial order for passed out students without allocating rank for failures?

thank you so much!!!

reallly goood teachinggg 💖💖💖💖💖💖💖💖

You're superb!

Thank you 🎉

Thank you so much brother

This is just awesome. I was having problems with my ICT tasks

Thank youuuu!

I have a question?.... Suppose a student who failed in one subject but score more in total mark then a student who score less in total mark but pass in all the subject... So, the question is how to make a rank on this kind of situation?

Thank you sir you the best teacher

Thanks a Lot Sir

Thank you 🙌

excellent explanation thank you for your valuable time for us....!

nice sir now my ict work is done

dear sir your video so excelent I was searching this kind of video . now I want how to print as a mark sheet kindly inform me . I am a teacher conducting exam, deportment , so i want to do all data works easily.

Excellent video😀😊😀😀😀😃😋

Thankyou sir

Nice and clear

thank u sir i have one doubt in case one student all subject have 35 marks 6*35=210 total another student one subject fail but this students 6-subject total 275 so how to calculate RANK ?? sir pls help me

Thanks bro ❤️

Thank you

THANK YOU SO MUCH

TNANKS A TON

Thanks

Thanks sir 👍🙏

Thankyou bro

Thank u so much ❤😊

Sir please tell me that how to sort the list of students based on the final average marks?

Thanks bro

Perfect Sir

Thank you so much sir 🙏🙏🙏🙏🤩🤩🤩🤩.

It was eassy explanation one query if I want to count how many students are fail in each subject than filter to be used count method

Thank you so much

Hi Sir, If a student failed also you have given the status as good you have to include this condition as well both should be satisfied.

How quickly Mr. Ram went from being class topper to fail 😅

nice bro thanks

thank you

This Rand formula did not work if there comes duplicate value. for example if two student gets the same number

Best teacher

Thank you sir for the explanation 🙏 👍 I understood how to do....thank you

nice information sir but i have a doubt .. when two students getting same marks then ranks also getting same but coming next rank person getting one rank below.... also i want to given conditions when student getting 400 above ranks on, above350 second rank like that.. how its came

Hi, thank you for your excellent video demo, however i wanted to know how can you calculate the to 5 marks only and displayed on your total column?

@AnilYadav-tt5ox

Жыл бұрын

W 4th

Nice work

How to use if function when any student is absent in all exam or particular subject.

I APPERECIATE YOU

Tq sir Excel Excellent sir

Thanks very much. please how can I know my total marks range if I'm using different value

prepare an exam results sheets of six of your friends in six different data sheets. each sheet will contain marks in four periodic assessments in english, hindi, maths, science and social science. rename these sheets with the name of your friends. now, combine all sheets in a seventh sheet to show the total obtained by each friend in each subject by using sheet referencing. now, find the total and average marks obtained by each of your friends by using combined data of all five subjects. finally, find minimum and maximum marks obtained in every subject and in combined marks. Can you make this video

Well explained very useful thank you

hi can you calculate how many students passed using sumif function, thank yu

Thank u

Very nice sir

I really di understand

THANK u

Super explanation Sir. Sir I want to know Function Library in FORMULAS TAB . PLEASE explain Sir

Sir Thanks 😊😊 Thanks Thankyou soooooooooo oo much My daout is clear 🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰

thanks

Thank You Sir

EXCELLENT