स्कूल में सभी कक्षाओं के रोल नंबर शीट बनाने में ऐसा कोई फार्मूला बताए की कक्षा के अनुसार वह शुरू के अंक वही ले ले जो लेफ्ट फार्मूले से ले सकते हैं और अगले अंक क्रमशः बढ़ते जाएं इसके बाद अगली क्लास आए तो फिर वही एक से बच्चों की संख्या तक रोल नंबर मिल जाए फिर अगली क्लास में भी वही हो
WAH THANK YOU SIR JI KITNE DINO SE YE FORMULA DHUNDH RAHA THA AAPNE BATA DIYA IS LIYE THANK YOU SOSOSOSOSOOSOSOOS MUCHCHCHCHCH BUT SATHE ME YE BATA DIJIYE KE YE FORMULAA MS OFFICE KE KONE SE VERSION ME AATA HE PLEASE
Sir, it's ok, but when we insart a new row then that row is showing blank, we can not fill the serial number automatically? I am talking about last 2 formulas
Hi, How Can I use this in Pivot Table, as I am Sorting my Pivot data on Value and Filtering out Non Zero values, So that I can have only positives and Negatives, further the Series should apply to this Pivot visible cells only !, any thoughts thank you in advance
Sir beautiful can you guide me Aggregate formula with array function so that it formula is inserted in whole column Does this work for Google sheet also 🙏
Sir hello . Sir mere Office mein ek computer k excel mein jub bhi mein s. Likhta Hun wahan Sunil ka name ajata hai . Ya serial . Likhta Hun thab bhi Sunil ata hai kindly iska solution Bata dein.
mere pass multiple account number for example excel sheet me 1 10 baar likha hua hai to mein chahta hoo ki serial number 1 se 10 tak count kare ye to ho jayega ab baat aati hai jaise hi 2 start hua to serial number dobara 1 se start hona chahiye aisa ko trik ya formula hai to please share kare urgent need Thank you
Sir ,ek problem graphics driver Out dated ,lekin updates bhi nehin ho rahi he . Core i5 2400 (3.10Ghz) Please Sir Suggest kijiye . Konsa sahi he .. 🙏🙏🙏🙏🙏🙏🙏
Sir agar ham row add karen tab koi b formula kaam ni karta. Is condition ma hamen added row ma dobara formula copy karna parta ha koi aisa tariqa btaen k jo row ham insert karen us ma b auto counting add ho
maan lo aapne column "A" me serial number lena hai or Column "C" me data enter karna hai to ek helper column ki jarurat padegi main example bata raha hu aap isko dekh kar samajh sakti hain. A B C S.No. Helper Column Data 1a a Ram 1b b Shyam 1c c Geeta d a b c d a ham A2 me formula lagayenge =IF(C2="","",COUNTIF($B$2:B2,B2)&B2) formula lagane ke baad aap column "B" ko hide kar sakti hain
Aapki video aur samjhane ka tari ka gajab ha
Excellent, Good practice is required to get command on it
Sir me abhi apki ms word video dekh rahii thi..BHT Acha lagta hai apka channel...ap BHT Acha samjhate hain...love from pakistan🇵🇰🇵🇰🇵🇰🇵🇰❤️❤️❤️❤️
Sir dhanyawad aapka, bohot madad Hui aapke is tutorial se. ❤️
Kamal sir please est hi tip and tricks py ziada videos banaya krein Sumproduct py ik details sy video banaye love from Pakistan
बहोत बढीया जानकारी. धन्यवाद.
Such really amazing formule sir...This taught me great ...Mind blowing sir
Its too useful, almost in every work, every sheet ! thanks a lot ! keep making such useful videos !
Thanks for sharing such wonderful video.
स्कूल में सभी कक्षाओं के रोल नंबर शीट बनाने में ऐसा कोई फार्मूला बताए की कक्षा के अनुसार वह शुरू के अंक वही ले ले जो लेफ्ट फार्मूले से ले सकते हैं और अगले अंक क्रमशः बढ़ते जाएं इसके बाद अगली क्लास आए तो फिर वही एक से बच्चों की संख्या तक रोल नंबर मिल जाए फिर अगली क्लास में भी वही हो
Good one sir. It helps me.Thank You
sir very nice the method of yours very good
Good work Manoj Sir. Keep good work and be safe. Respect form Pakistan.
BAHUT ACHI POST HAI SIR
Very good way of explanation...Thank you so much...
Very helpful video.. excellent work sirji..
Nice presentation, It's helpful for us. Thanks.
I like this very much, your thanks
It is very useful sir 👍
Sir your knowledge about excel is great. Plz keep up making vedio like it.
Thank you, I will
WAH THANK YOU SIR JI KITNE DINO SE YE FORMULA DHUNDH RAHA THA AAPNE BATA DIYA IS LIYE THANK YOU SOSOSOSOSOOSOSOOS MUCHCHCHCHCH BUT SATHE ME YE BATA DIJIYE KE YE FORMULAA MS OFFICE KE KONE SE VERSION ME AATA HE PLEASE
This video is very useful👍
How to create a cash book with aggregate formula ?
Keep watching
Very good sir 👍🇮🇳
Excellent video 🙏
Happy holi sir
Aapki video bade kaam ki ha
Thanks! Very High
Very nice formula sir
Sir you have explained it very well. Thanks a lot. 🌺🌺
Sir please Google sheet ka tutorial beginners se advance Tak
Yes sir please
@@devendranishad9150 p
हर क्लास से नया सीरीज चालू हो ऐसा ट्रिक बताएं।
Excellent formula
Thank you sir
I agree 👍👍👍💯
=subtotal(3,$D$2:D2)
Pls try this one also
WELL EXPLAINED
Sir Subtotal with Counta ka bhi use kr sakte hai for auto serial.
That Great . Excellent Dear. How I Auto Generate Serial Number in Google Sheet. kya ye kam hm google sheet ma apply kar sakty hai
Thank you.....
Thank you sir
Very Nice sir
Nice Sir
बेहतरीन❤️❤️
Nice helpful
দারুন
Hide karne se total kaise change joga.
Pl.make video.
Filter lagane pe use hoya kya ??
Superb
I LIKE IT
जय हो गुरु
Happy Diwali sir,
Great Sir
Sirji, I am a regular viewer of ur channel, can u give the link of the first Aggregate video, thanks
Nice
Sir,
Excel 2007 main aggregate key se work korega.
Nice!
Excel magic
What happen if we insert a row? Should it count next number? Or we have to use any other formula? Plz guid
Nice video
Sir pehle se kuch entries ho rakhi hai.
Par ab sr. No. Kuch naye rarike se karna hai wo bhi Text+number, kaise hoga
how to auto insert different amounts in eight excel cells by fixing the selected amount with sum
Very nice video, sir which screen recorder and editor you use
Camtasia
Is this aggreate formula works with fully Filterd and fully validated sheet ?
Happy diwali
I need help i want to restart serial no after each 31 december
If I drag down then sl no came automatically present there before typing name.
Sir, it's ok, but when we insart a new row then that row is showing blank, we can not fill the serial number automatically?
I am talking about last 2 formulas
Hi, How Can I use this in Pivot Table, as I am Sorting my Pivot data on Value and Filtering out Non Zero values, So that I can have only positives and Negatives, further the Series should apply to this Pivot visible cells only !, any thoughts thank you in advance
Sir i have one doubt in this concept, still now i did not get right , How can i explain the doubt to u? Regarding serial number for sumed values
Sir, please tell me if I want to write a continuous serial number from 1to 7000 on a A3 Page,then how to do
Sir plz ek video banaye ki page number kaise change krege ek hi cell mein example 1 of 100 h mujhe next cell mein 2 of 100 krna ho to
Aapne hide aur delete ka dhika Diya par kya ye add raw pe Kam karega?
Yes
Data ko table me convert kar lo
sir kya hum today date ek cell me h jab next day me new cell me auto matik agli date aa jave
If I want to insert new rows above the table then not work properly
Sir beautiful
can you guide me Aggregate formula with array function so that it formula is inserted in whole column
Does this work for Google sheet also 🙏
AGGREGATE function not available in google XL sheets. whats the other options.
Sir jis cell me formula laga hai waha value aaye , jisme value nahi hai waha 0 ki jagah Hypen kaise aayega bataiye
Hi sir i need serial number every page break
hello good morning, sir i have one question how i can get the mobile second imei if i have 1st imei
I filled data in Excel rows, with alternative and now I have to do sr.no.with those row only.. plz help me
Sir hello .
Sir mere Office mein ek computer k excel mein jub bhi mein s. Likhta Hun wahan Sunil ka name ajata hai . Ya serial . Likhta Hun thab bhi Sunil ata hai kindly iska solution Bata dein.
Sir, if we add a row in between will this aggregate formula work?
mere pass multiple account number for example excel sheet me 1 10 baar likha hua hai to mein chahta hoo ki serial number 1 se 10 tak count kare ye to ho jayega ab baat aati hai jaise hi 2 start hua to serial number dobara 1 se start hona chahiye aisa ko trik ya formula hai to please share kare urgent need
Thank you
Sir
If a row is blank in the data then this formula will work?
yes this formula also work because we used "","" blank in formula.
How To Do It For Dates Instead Of Serial Numbers...Please Explain!!!
Sir ,ek problem graphics driver Out dated ,lekin updates bhi nehin ho rahi he .
Core i5 2400 (3.10Ghz)
Please Sir Suggest kijiye .
Konsa sahi he ..
🙏🙏🙏🙏🙏🙏🙏
aapka motherboard konsa hai uske naam se or jo window use kar rahe ho us version se search karo mil jayega
@@ComputerGyanGuruji Mother Board- Gigabyte ,H61M-S (Window 10)
Bahot Try Kiya .....Please Sir ...
Please Sir 🙏🙏🙏🙏
Sir, aggregate formula is not available in 2007 i think
In excel 2007 aggregate function not listed itself why?
Please mention in the video which ms Excel version is this. This formula is not working in ms Excel 2010.
2013 and above
Sir Maine Same Fourmula Use Kiya Delete Karne Par Ref Error Aa Raha Hai
Aggregate count or counta is not working in table format
It's Amazing Formula. But it's not working in Good Sheets. Kindly share for Google Sheets.
Sir agar ham row add karen tab koi b formula kaam ni karta. Is condition ma hamen added row ma dobara formula copy karna parta ha koi aisa tariqa btaen k jo row ham insert karen us ma b auto counting add ho
Sir I would suggest k apko new channel banana chahiye...sir I will really follow ur channel🇵🇰❤️
Sir this formula can use Google sheet.
office 13,16,19 and google sheet
@@ComputerGyanGuruji but I don't use this formula in Google sheets
How to achieve it without using aggregate function as it is not working in my workbook
Sir ye 2007 me Nahi chalega Kya
Aggregate function not works in old excel version
Sir thousands me subscriber hain..or views hundred me.....q sir..???
gREAT sIR
1a, 1b, 1c, 1d,2a, 2b, 2c, 2d serial kayasa karungi? Pls help me
keep watching
maan lo aapne column "A" me serial number lena hai or Column "C" me data enter karna hai to ek helper column ki jarurat padegi main example bata raha hu aap isko dekh kar samajh sakti hain.
A B C
S.No. Helper Column Data
1a a Ram
1b b Shyam
1c c Geeta
d
a
b
c
d
a
ham A2 me formula lagayenge
=IF(C2="","",COUNTIF($B$2:B2,B2)&B2)
formula lagane ke baad aap column "B" ko hide kar sakti hain