Auto sort when data change or add in excel | sort data automatically with formula and VBA macro (CC)

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

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

50% 1

Your learn in this video data entry with Auto sort when data change or add in excel | sort data automatically with formula and VBA macro. auto sort excel formula and auto sort vba macro.
#autosortdata #sortautomatically #sortfilterdatainexcel #msexcel #computergyanguruji
Download VBA Code:- futurecomputer...
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 ...
Excel VBA
• Excel VBA
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...
CSS
• Introduction to CSS | ...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Google Sheet
• google sheet
Reasoning
• Reasoning
Airthmatics
• Airthmetic

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

21 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@ANANDKUMAR-hp5gk 3 года назад

Sir apka batane ka tarika aur jankari bahut _2 hi achcha hai, jis ki jitani tarif ki jaye kam hai,

@f_ormobile Год назад

works perfectly. thank you

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

*_THANK YOU SIR...._*

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

RU-vid par Apke alawa koi aur vba Ka video nhi banaya thank you

@ManojKumar-ti6eg 10 месяцев назад

By using Vlookup formula, what if sorting numbers (Marks) are same in more than 2 cells. So Vlookup will pickup only 1st Name. Right.? That won't be useful in that case. Please correct me if im wrong. Also for VBA code, how it will behave in the above case.?

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

Real useful idea 👏👏👏👌👌👍

@Bhagrcyt Год назад

WIll this VBA Code work for Online Excel as well?

@durgarao1991 Год назад

Great sir 👏

@KavyaPawar1 Год назад

Dear Sir pls tell how to record lowest & highest value of continue change cell value... in particular cell

@KavyaPawar1 Год назад

Dear Sir pls tell how to record lowest & highest value of continue change cell value in particular cell.

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

Great sir

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

Thank you so much

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

Thanks

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

Asalam o alikum sir .. apka html and css tutorial bht acha hy .. ab ap Java script ka b tutorial upload krain

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

soon

@PrashantSingh-mb1sz 2 года назад

Sir time k sath koi data auto update hota rhe is topic pr vdo bnaiye plzzz

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

sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable

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

Sir ,What we do if two students get same marks …. Using index function and vlookup , is it possible to do sort

@KvNarayana-gh8ug Год назад

Good Morning Sir, Is it possible to sort same marks have four students. I have already tried but only first student name is reflecting against four students. Can you held on this please.

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

thx sir

@RahulRaj-gx6nd Год назад

Sir how do we short 1/1 1/2 1/4 1/3 These type of data

@vinodsolanki7030 Год назад

Good afternoon sir apke video se hame kafi kuch shikne ko mil raha he iske liye bohat bohat dhanyvad, sir mujhe esi formula chahiye jese ke koi do figar ka total 537 he to yahi total vali figar uske bajuke સેલ me 357 se jawab aye matlab chadte kram me agar easa ho sakta he to plz muje jarur bataiye ધન્યવાદ

@pratikvirani1353 Год назад

hello ji , is me aha=gar same number he to name thi same ho ja rahaheh , to iska kya solution he

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

Sir could you please make a video that how can we zoom out the tab bar of ms word and excel as we zoom out and zoom in Document

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

Use Ctrl+scroll mouse wheel

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

@@ComputerGyanGuruji Sir I mean How can we zoom out the Insert,home,layout tabe etc.With ctrl plus mouse wheel we can only zoom out and zoom in documents area

@maninder8776 Год назад

If we add another column of % (in which we use percent formula) and sort with maximum percentage with up to down & name should be also sort as well as Then what formula will apply

@AbdulSattar-ox8jt Год назад

exactly what i want to know

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

Dear sir,good morning,mujhe VBA coding me problem ho rhi hai,mai 3 speedometer chart banaya hu (quality score%, process score %,skill score%)pr pivot table score se connect(=$A$2) krne pr speedometer work nhi kr rh hai,coding me problem ho rhi hai ,plz help me....

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

Good

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

Sorry how if to get the small first

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

If 2 different persons have same numbers then?

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

2 different persons have same number or same name, then use another formula like, dget, vlookup with multiple criteria, vlookup with multiple lookup value, which is already upload please watch our "ms excel" play list or "ms excel for beginners" play list.

@sayediftekharraheman6324 9 месяцев назад

Good Evening sir ji, Sir me ek stock ka table banaya hai jisme main biscuit, cake and cookies ko ek hi table me record karta hoo and every day kuch naya naya item add hota rehta hai. To sir mera question ye he ki me every item ko ek hi table me rakhte hue alag category me rakhte hue Kia tarah ascending order me sort Karu....... please sir ispar ek video ya koi dusre tarike yani messeges ki madad se agar mujhe guide kar den to bohot hi meherbani hogi. Please sir help me 🙏🙏🙏🙏 Mene aapka Sara video dekha hai khas kar html ka pura series mene aap hi se sikha hai.

@ComputerGyanGuruji 9 месяцев назад

aapka sujhav achchha laga is par ham ek video bhi banayenge or yadi aap kar sakte hain to "sort and filter formula" appy kar sakte hain ya manual sort karke uska macro record kar sakte hain.

@sayediftekharraheman6324 9 месяцев назад

Bohot Bohot Shukriya Sir Reply karne ke liye... Sir me table me sort karta hoo lekin Sara tittar bittar ho jaata hai. To mene aapse pucha. Agar aap kahenge to me aapko screenshot bhejna chahunga....

@lazybun_india5134 Год назад

... THE CODE IS WORKING WITH TABLE OPTION..... BUT WOH DESCENDING ME KAR RAHA HAI... HOW TO DO IT ASCENDING

@ABDULAZIZ-zs7wj Год назад

This formula gives error on many same value please give solution

@kirtisharma2373 Год назад

sir, why A2 ? we are using ...C:C ...then why not C2?

@TheVoiceOfPeople- 2 года назад

Hi sir muje excel me ek work karana hai par muje kuch idea nahi aa raha hai ki kese karu me aapni excel aapke sath share karana chahata hu please help me kese share kar shakata hu file aapko muje pata hai aap uska solution de payege sir please help 🙏🙏🙏

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

jangirgolums2@gmail.com

@TheVoiceOfPeople- 2 года назад

@@ComputerGyanGuruji thank You sir

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

Sir good afternoon, how to sort alpha numeric data of pivot table in Excel VBA

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

Pls dear code in distribution thank you

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

Check description

@YOGESHSAHU-kc6gu Год назад

एक जैसा नंबर लेता है रहता है तो वह एक ही नाम को लेता है बार-बार

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

Jab number repeat hota hai to.example 400 and 400 repeat.first hi show hotahai second nhi

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

bro uske liye hamne pahle videos me bataya hai jaise "dget" formula ya vlookup with multiple lookup value etc. iske liye aapko hamare vlookup ke video dekhne honge. Hlookup ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-clB-X1mzsMA.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-j6M9abw_hcM.html Vlookup ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Y4x8FJVvKs8.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ocTWjPdhzOk.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FLLCoNTPqdE.html