Auto Generate Serial Number Using Aggregate Formula in excel | Magic of Aggregate Formula 4 examples
HTML-код
- Опубликовано: 4 окт 2024
- Auto Generate Serial Number Using Aggregate Formula in excel | Magic of Aggregate Formula 4 examples
#aggregateformula #autoserialnumber #msexcel #computergyanguruji
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
Its too useful, almost in every work, every sheet ! thanks a lot ! keep making such useful videos !
Sir me abhi apki ms word video dekh rahii thi..BHT Acha lagta hai apka channel...ap BHT Acha samjhate hain...love from pakistan🇵🇰🇵🇰🇵🇰🇵🇰❤️❤️❤️❤️
Such really amazing formule sir...This taught me great ...Mind blowing sir
Good one sir. It helps me.Thank You
स्कूल में सभी कक्षाओं के रोल नंबर शीट बनाने में ऐसा कोई फार्मूला बताए की कक्षा के अनुसार वह शुरू के अंक वही ले ले जो लेफ्ट फार्मूले से ले सकते हैं और अगले अंक क्रमशः बढ़ते जाएं इसके बाद अगली क्लास आए तो फिर वही एक से बच्चों की संख्या तक रोल नंबर मिल जाए फिर अगली क्लास में भी वही हो
Thanks for sharing such wonderful video.
Sir dhanyawad aapka, bohot madad Hui aapke is tutorial se. ❤️
Excellent, Good practice is required to get command on it
sir very nice the method of yours very good
बहोत बढीया जानकारी. धन्यवाद.
Kamal sir please est hi tip and tricks py ziada videos banaya krein Sumproduct py ik details sy video banaye love from Pakistan
Very helpful video.. excellent work sirji..
Sir your knowledge about excel is great. Plz keep up making vedio like it.
Thank you, I will
Nice presentation, It's helpful for us. Thanks.
Very good way of explanation...Thank you so much...
I like this very much, your thanks
Good work Manoj Sir. Keep good work and be safe. Respect form Pakistan.
It is very useful sir 👍
BAHUT ACHI POST HAI SIR
Very nice formula sir
Excellent video 🙏
Sir you have explained it very well. Thanks a lot. 🌺🌺
Very good sir 👍🇮🇳
Thanks! Very High
WELL EXPLAINED
Nice Sir
Thank you sir
I agree 👍👍👍💯
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
Excellent formula
Sir please Google sheet ka tutorial beginners se advance Tak
Yes sir please
@@devendranishad9150 p
Thank you sir
हर क्लास से नया सीरीज चालू हो ऐसा ट्रिक बताएं।
Thank you.....
That Great . Excellent Dear. How I Auto Generate Serial Number in Google Sheet. kya ye kam hm google sheet ma apply kar sakty hai
Good
Nice helpful
बेहतरीन❤️❤️
Very Nice sir
Sir Subtotal with Counta ka bhi use kr sakte hai for auto serial.
This video is very useful👍
How to create a cash book with aggregate formula ?
Keep watching
Superb
Great Sir
দারুন
Filter lagane pe use hoya kya ??
Happy holi sir
Sirji, I am a regular viewer of ur channel, can u give the link of the first Aggregate video, thanks
=subtotal(3,$D$2:D2)
Pls try this one also
जय हो गुरु
Nice!
Nice video
Happy Diwali sir,
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
I LIKE IT
Sir pehle se kuch entries ho rakhi hai.
Par ab sr. No. Kuch naye rarike se karna hai wo bhi Text+number, kaise hoga
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
Very nice video, sir which screen recorder and editor you use
Camtasia
Happy diwali
If I drag down then sl no came automatically present there before typing name.
Sir,
Excel 2007 main aggregate key se work korega.
Hide karne se total kaise change joga.
Pl.make video.
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
What happen if we insert a row? Should it count next number? Or we have to use any other formula? Plz guid
Is this aggreate formula works with fully Filterd and fully validated sheet ?
I need help i want to restart serial no after each 31 december
sir kya hum today date ek cell me h jab next day me new cell me auto matik agli date aa jave
I filled data in Excel rows, with alternative and now I have to do sr.no.with those row only.. plz help me
Sir I would suggest k apko new channel banana chahiye...sir I will really follow ur channel🇵🇰❤️
Sir, please tell me if I want to write a continuous serial number from 1to 7000 on a A3 Page,then how to do
AGGREGATE function not available in google XL sheets. whats the other options.
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?
how to auto insert different amounts in eight excel cells by fixing the selected amount with sum
If I want to insert new rows above the table then not work properly
Sir jis cell me formula laga hai waha value aaye , jisme value nahi hai waha 0 ki jagah Hypen kaise aayega bataiye
It's Amazing Formula. But it's not working in Good Sheets. Kindly share for Google Sheets.
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.
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 🙏
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 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
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 thousands me subscriber hain..or views hundred me.....q sir..???
Aapne hide aur delete ka dhika Diya par kya ye add raw pe Kam karega?
Yes
Data ko table me convert kar lo
hello good morning, sir i have one question how i can get the mobile second imei if i have 1st imei
Please mention in the video which ms Excel version is this. This formula is not working in ms Excel 2010.
2013 and above
In excel 2007 aggregate function not listed itself why?
How To Do It For Dates Instead Of Serial Numbers...Please Explain!!!
Sir ye 2007 me Nahi chalega Kya
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, aggregate formula is not available in 2007 i think
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
gREAT sIR
Aggregate count or counta is not working in table format
Hi sir i need serial number every page break
Aggregate formula is not working in my excel 2007
How to achieve it without using aggregate function as it is not working in my workbook
Sir how to apply a serial number to single journal entry in excel? e.g
Dr. Rent 2000
Dr. Salary 5000
Cr. Cash 3000
Cr. Bank 4000
Aggregate farmula nahi kam kar raha hai as =AGGREGATE (2,5,$G$3:G3)
एक्सेल में Purchases file और sale file दो अलग अलग file बना हुआ है , और purchases file में मोबाइल का अलग अलग सीरियल नंबर अलग अलग कॉलम में एंटर किया हुआ है , और एक्सेल का दूसरे फाइल सेल में पर्चासेस वाला सीरियल एंटर करते ही पर्चासेस फाइल के अंडर उस सीरियल कॉलम का कलर चेंज हो जाये ,
Pl share the formula,
Sir ji CSS 2nd part
Fraz Pakistan
Aggregate function not works in old excel version