Auto Generate Serial Number Using Aggregate Formula in excel | Magic of Aggregate Formula 4 examples

Подписаться 408 тыс.

Просмотров 168 тыс.

50% 1

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

Опубликовано:

2 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 147

@creativeurooj 3 года назад

Sir me abhi apki ms word video dekh rahii thi..BHT Acha lagta hai apka channel...ap BHT Acha samjhate hain...love from pakistan🇵🇰🇵🇰🇵🇰🇵🇰❤️❤️❤️❤️

@deepjyotistories 2 года назад

Sir dhanyawad aapka, bohot madad Hui aapke is tutorial se. ❤️

@vikikhan8765 3 года назад

BAHUT ACHI POST HAI SIR

@anilsrivastav9109 3 года назад

I like this very much, your thanks

@manjit.sarania Год назад

Very nice formula sir

@sureshnagwan7805 3 года назад

Excellent video 🙏

@sarvodayaconventvidisha1757 2 года назад

स्कूल में सभी कक्षाओं के रोल नंबर शीट बनाने में ऐसा कोई फार्मूला बताए की कक्षा के अनुसार वह शुरू के अंक वही ले ले जो लेफ्ट फार्मूले से ले सकते हैं और अगले अंक क्रमशः बढ़ते जाएं इसके बाद अगली क्लास आए तो फिर वही एक से बच्चों की संख्या तक रोल नंबर मिल जाए फिर अगली क्लास में भी वही हो

@rakesh-9924 2 года назад

Thank you.....

@sanjeevkumarmishra1628 3 года назад

Great Sir

@manojindrasan95 3 года назад

Nice video

@mohammedhashim7994 2 года назад

Sirji, I am a regular viewer of ur channel, can u give the link of the first Aggregate video, thanks

@creativeurooj 3 года назад

Sir I would suggest k apko new channel banana chahiye...sir I will really follow ur channel🇵🇰❤️

@mohammadsafiqulislam5779 2 года назад

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

@labanyabaishya2853 6 месяцев назад

If I drag down then sl no came automatically present there before typing name.

@saurabhshukla8230 Месяц назад

Sir jis cell me formula laga hai waha value aaye , jisme value nahi hai waha 0 ki jagah Hypen kaise aayega bataiye

@muralitallapudi6156 Год назад

AGGREGATE function not available in google XL sheets. whats the other options.

@sayyedaarifali2012 3 года назад

What happen if we insert a row? Should it count next number? Or we have to use any other formula? Plz guid

@ahmadriaz6387 2 года назад

Is this aggreate formula works with fully Filterd and fully validated sheet ?

@sheikhmd.ziauddin.russell3688 2 года назад

how to auto insert different amounts in eight excel cells by fixing the selected amount with sum

@husainnajmi 5 месяцев назад

Aggregate count or counta is not working in table format

@motiramlatpate9043 3 года назад

I filled data in Excel rows, with alternative and now I have to do sr.no.with those row only.. plz help me

@MuhammadUsman-vz3kv Год назад

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

@creativeurooj 3 года назад

Sir thousands me subscriber hain..or views hundred me.....q sir..???

@ashwanisharma3972 Год назад

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

@Edu.carenarmada 3 года назад

In excel 2007 aggregate function not listed itself why?

@shaifulislam6746 3 года назад

Sir please Google sheet ka tutorial beginners se advance Tak

@devendranishad9150 2 года назад

Yes sir please

@shobhansualkuchi2873 2 года назад

@@devendranishad9150 p

@abhaykumar-mj1mj 3 года назад

Aggregate farmula nahi kam kar raha hai as =AGGREGATE (2,5,$G$3:G3)

@shaifulislam6746 3 года назад

Sir this formula can use Google sheet.

@ComputerGyanGuruji 3 года назад

office 13,16,19 and google sheet

@shaifulislam6746 3 года назад

@@ComputerGyanGuruji but I don't use this formula in Google sheets

@sarfarazahmed5775 3 года назад

Sir ji CSS 2nd part Fraz Pakistan

@mineshsuthar622 Год назад

Auto Sr. No. by every month first date, (1/4/20##,1/5/20##) Auto Sr. No. by every year first date (1/4/2023,1/4/2024)

@mukeshgupta4583 3 года назад

=subtotal(3,$D$2:D2) Pls try this one also

@Kingx7565 3 года назад

Kamal sir please est hi tip and tricks py ziada videos banaya krein Sumproduct py ik details sy video banaye love from Pakistan

@ruplove4791 2 года назад

1a, 1b, 1c, 1d,2a, 2b, 2c, 2d serial kayasa karungi? Pls help me

@ComputerGyanGuruji 2 года назад

keep watching

@ComputerGyanGuruji 2 года назад

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

@shirinalam8186 3 года назад

Sir, aggregate formula is not available in 2007 i think

@nizamuddin8097 2 года назад

It's Amazing Formula. But it's not working in Good Sheets. Kindly share for Google Sheets.

@mohanpal13555 3 года назад

Plz Send me excel practice this vedio

@dineshcpathak844 Год назад

एक्सेल में Purchases file और sale file दो अलग अलग file बना हुआ है , और purchases file में मोबाइल का अलग अलग सीरियल नंबर अलग अलग कॉलम में एंटर किया हुआ है , और एक्सेल का दूसरे फाइल सेल में पर्चासेस वाला सीरियल एंटर करते ही पर्चासेस फाइल के अंडर उस सीरियल कॉलम का कलर चेंज हो जाये , Pl share the formula,

@hasnainansari4362 3 года назад

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

@gauravjain9580 3 года назад

Its too useful, almost in every work, every sheet ! thanks a lot ! keep making such useful videos !

@SUR-NI-VARA 2 года назад

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

@mr.morpalu 3 года назад

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 .. 🙏🙏🙏🙏🙏🙏🙏

@ComputerGyanGuruji 3 года назад

aapka motherboard konsa hai uske naam se or jo window use kar rahe ho us version se search karo mil jayega

@mr.morpalu 3 года назад

@@ComputerGyanGuruji Mother Board- Gigabyte ,H61M-S (Window 10)

@mr.morpalu 3 года назад

Bahot Try Kiya .....Please Sir ...

@mr.morpalu 3 года назад

Please Sir 🙏🙏🙏🙏

@nitinverma8772 3 года назад

Aggregate formula is not working in my excel 2007

@mohanpal13555 3 года назад

Such really amazing formule sir...This taught me great ...Mind blowing sir

@asadali2304 Год назад

hello good morning, sir i have one question how i can get the mobile second imei if i have 1st imei

@basantkumarchandola2897 Год назад

Sir यदि कॉलम ए में फॉर्मूला लगा हो और कॉलम blank हो तो ये फॉर्मूला काम नही कर रहा है। कृपया इसका हल बताने की कृपा करें।

@gopidey348 Год назад

Sir, Excel 2007 main aggregate key se work korega.

@shbangash437 Год назад

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.

@centuriongamers2674 2 года назад

I need help i want to restart serial no after each 31 december

@sunilkamarsharma8481 2 года назад

If I want to insert new rows above the table then not work properly

@rohankumar3567 3 года назад

Sir Subtotal with Counta ka bhi use kr sakte hai for auto serial.

@kanubhattacharya5481 3 года назад

Sir pehle se kuch entries ho rakhi hai. Par ab sr. No. Kuch naye rarike se karna hai wo bhi Text+number, kaise hoga

@junaidiqbal9157 2 года назад

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

@Ramdhakal 3 года назад

Hi sir i need serial number every page break

@hemanthraj8227 Год назад

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

@monalizaaraujo5310 Год назад

Sir, please tell me if I want to write a continuous serial number from 1to 7000 on a A3 Page,then how to do

@shaifulislam6746 3 года назад

Happy diwali

@umeshdhakrey4925 3 года назад

सर मैं चाहता हूं कोई भी संख्या जैसे 50,000 ही मान लूं मुझे इसे 30 डेट में या फिर 30 दिन में डिवाइड करना है और अमाउंट सबका अलग-अलग आए और सब टोटल करें तो नीचे 50,000 ही आए ऐसा कोई फार्मूला बताओ ऐसा मैं अपने हिसाब से लिखते लिखते परेशान हो जाता हूं

@jstech8616 Год назад

sir kya hum today date ek cell me h jab next day me new cell me auto matik agli date aa jave

@hamad50501 6 месяцев назад

That Great . Excellent Dear. How I Auto Generate Serial Number in Google Sheet. kya ye kam hm google sheet ma apply kar sakty hai

@jibanbhaiofficial 2 года назад

Aggregate formula Nehi hai 2007 me

@kishorkulkarni4120 3 года назад

How to achieve it without using aggregate function as it is not working in my workbook

@vilasdhalke Месяц назад

Good one sir. It helps me.Thank You

@virenderkamboj4176 2 года назад

Sir serial nu.. Age peche ho gy unhe serial me kese kre

@vijaytrivedi1543 3 года назад

Mare office 2007 exclema aggregate formula aavti nathi...To shu karavu.

@ComputerGyanGuruji 3 года назад

aap google sheet ka use kar sakte hain

@husainnajmi 5 месяцев назад

Plz guide

@Motivation-bro- 2 года назад

Filter lagane pe use hoya kya ??

@keshavprasad-bm3cg 4 месяца назад

Good

@sweetniniseth410 3 года назад

Sir mera wala 2007 hai Isme aggregate formula nehi aa raha hai

@ComputerGyanGuruji 3 года назад

use office 13,16,19 or Google sheet

@AzaamKhanCloser Год назад

gREAT sIR

@tech11.786 Год назад

Nice Sir

@samayasaadhakarus757 3 года назад

How To Do It For Dates Instead Of Serial Numbers...Please Explain!!!

@rkyoutuber521 3 года назад

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

@DeepakKumar-od3mx 2 года назад

Sir ye 2007 me Nahi chalega Kya

@NoorAli71184 3 месяца назад

sir very nice the method of yours very good

@shivhukre4512 3 года назад

Aggregate function not works in old excel version

@abhimankhade7628 Год назад

Excellent, Good practice is required to get command on it

@Rk-bh7ru 6 месяцев назад

हर क्लास से नया सीरीज चालू हो ऐसा ट्रिक बताएं।

@durgarao1991 Год назад

Good

@usmanrafiq-x8q Год назад

UPDATE NA HOON YEH REQUIRED HY.. AIK BILL PAY KER K DIYA PAID NO K SATH... YEH DIARY PAID HO GAYEE.. CHANGE NA HO BLK KHUD HI NEXT BILL NMBR DARJ HO

@ranvirsingh4950 Год назад

Thanks for sharing such wonderful video.

@seedhibaat7741 3 года назад

Good work Manoj Sir. Keep good work and be safe. Respect form Pakistan.

@SUMANKUMAR-er6ih 3 года назад

Hide karne se total kaise change joga. Pl.make video.

@F35-i1q 3 года назад

Sir mere excal me nahi ho pa raha hai ye farmula nahi aa raha hai

@ComputerGyanGuruji 3 года назад

office 2013 or above me milega, aap google sheet ka use kar sakte hain

@hareshhemvani4781 2 года назад

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 🙏