𝟏𝟎 𝐍𝐄𝐖 𝐀𝐃𝐕𝐀𝐍𝐂𝐄𝐃 𝐅𝐎𝐑𝐌𝐔𝐋𝐀𝐒 𝐨𝐟 𝐄𝐗𝐂𝐄𝐋 𝐢𝐧 𝟐𝟎𝟐𝟒 (𝐇𝐢𝐧𝐝𝐢)

[@harishkumar4150]

🙏🙏🙏🙏 sir aapka padhane ka tarika bhut hi aacha hai💫💫💫💫💫💫💫💫💫💫💫💫💫💫💫special thanks

[@OfficeFreak]

Thank you so much Harish ☺️☺️☺️

[@ramuachari1036]

Ctrl E is best idea sir

[@OfficeFreak]

No doubt, Ctrl E is an awesome feature. It's my personal favorite 😊😊😊

[@gulfam_siddiquee]

👍

[@OfficeFreak]

Thank you so much for loving the video. Stay connected 😊

[@Sahil_Sial]

Kis office me ye formulas kaam karte hen, mere office kuch show nhe ho rahe aur kuch kaam nhe kar rahe

[@OfficeFreak]

2021 aur Ms Office 365

[@shubhamrathore3703]

I want to know one formula.
Amit 45/45
Amit. 59/34
Amit 92/45
Rahul 33/494
Rahul 45/45
Mere pas is tarah ka data he bahot sare log he isi tarah. Me chahta hu ye data is form me aajaye to kese hoga
Amit 45/45, 59/34, 92/45
Rahul 33/494, 45/45

[@OfficeFreak]

Let's understand this way...
Names are in Column B
1st name is starting from B2
Marks are in Column C
1st marks is in C2
Now you come to D2
=Unique(B2:B10)
Now come to E2
=Textjoin(",",True,If(D2=$B$2:$B$10,$C$2:$C$10,"")
Names are in the range, B2:10
Marks are in range, C2:C10