How to Create Beautiful Marksheet in Excel | formula | Conditional formatting, Rank, Percentage, SUM 

Legends watching before practical

Bahut hi helpful sir ji...🙏🙏

Very use full sir, thank u so much for this video

Kon kon practical exam sa ek din pehle dekha rha hai

Very useful and helpful especially for teachers while preparing results

Very helpful.. Thank you sir🙏

Zabrdast. Mashallah Mashallah

Very beautiful sir and very helpful tips

You are Awesome Sirji.... Thanks

Awesome 👍

Very helpful 👍

Thank you sir super 👌👌👌

It's very helpful sir..💯🥰

Thank you sir ache se samjhane ke liye ❤️

Bahud khob Sir Mashallah me Be prectes key Or kamyab hoia Allah Pak ke Karam se

Very useful for computer practicals thank you

Very nice method for making Excel sheet and formulas 🙏

Very nice laga

Aapka marketsheet sikhe liya thanks sir 🙏👌👌🙏

Bahut badiya

Very good

Excellent

Very helpful

Superb

So great inteliegence

This formula was amazing to workout .

Bahut achha

It's very useful thank you sir 😊

Bro, the rank is showing wrong Reason: you didn't lock the (range) to lock range , select it and click on F4 KEY

thank you sir it helped me a lot ❤❤❤❤❤

Kon kon ye video 2024 Main dekh raha hai 😅

Thanks for the video. How do we compile a list showing only students that failed? Separating it from those who passed

👍💐

Best❤

Bahut acha laga sir j

Good information

Thanks💜

Thank you🙏🙏❤❤❤

Thank you sir 🙏

अगर दो student के percent बराबर हो तो दोनों student के rank बराबर होगा या आगे पीछे । इस तरह के फार्मूले बताएँ

Thanks 🙏

Thank youuu❤️

🌹🌹🌹🌹 🌹🌹👍👍👍 Good presentation You explained slowly, thats why could understand 🌹🌹🌹🌹 🌹🌹🌹🌹👍🌹

From were I can download same as thi template? you can add a link the page Thanks, Regards .

Thanks brother ❤❤

Very nice sir

Thank u sir

Thank you😉

Good 👍👍👍

Thank you so much Sir 👌👌🙏🙏

Very nice video sir

thankful video sir

Thanks bro ❤

Thank u so much

Good

Thank you so much sir

So useful

Baki sbhi point clear h

Thnk u sooo much sir

👍👍👍👍👍👍

Thank you sir

Helpful video

👌👌

Thanks 👍

Thankss a lot sir

Sir ap jo subject mark dalte ho time lagega usi jagah main app Randbetween formula use kar sakte ho👍

very thanks sir

Accha laga

Very nice

Formula for Rank calculation should explain properly, because correct/proper result is not able to get by using the formula.

Fast forwarding mast tha😂😂

Sir formula pr tab bhi kr sakte hai to select right right

Many many thanks

Thanks a lot,

Very helpful vedio sir

very good

Tq sir

Thanks bro

Why do we need to learn a little bit of everything Technical office staff should do such work

Rank ku size kori goty video korontu

Screen big kijiye taaki clearly dikhayi de

PALL "PASS"😹

Nyc

Nice

Sir sr.no 1,2 likh kr baki sr.no kese aayege vo bta do first baar excel pe table bnana hai

🙏

Legends watching 2 hours before practical

ASSLAM O ALAIKUM SIR , all rows ke hight equaly q nahi barh rahi sir

(1) Fail ko Rank nahi milta bhai. (2) jo Desable Student hote he vo 20 mark se pass ho jate he. Baki normal student 33 se pass.

Legends watching from pakistan for practicals

How to keep constant

Thank you sir💞

RANKING TORI SMAJH NHI AAHI

RANK SAHI NHI NIKAL RAHI HE. RANK NIKALNE KE LIYE CLEAR KOI VIDEO BANAO SIR.

Sir, When we are using the rank formula. Any two students who got the same percentage. Like Student A: 98% Student B: 98% Student C: 97% Student D: 96 the rank will show the result of A and B at first position and Student C will be shown on 3rd position. In the rank formula it miss the second position holder or duplicate percentage. How to fix it

Very nice👍

Use Randbetween for marks

Rank galat dikha raha ha... Rahim ko 41.75% Mila haa rank 2nd🙄 but Rohon ko 68.75% Mila haa rank 3 🙄🙄🙄☹️ and 2-2 2nd and 2-2 3rd...not understanding ☹️🙄

*fast forward mein mouse ki voice jaise voice aa rhi h 😆*

Aur bhi pass fail formula aise nahi hote sir jab ek student 60% rakhte hai to 1st division milta hai aur kam rakhte hai to fail nahi hote aur jo division milta hai