Data Entry with Auto Sort | Ascending or Descending order |Excel Magic Tricks

[@shrikantbadge3978]

Excel k मामले में मैं था बडा कडका बाद में लाया दीपक सर ने tricks and tips का तडका फिर तो भैया ऑफिस मे मेरा ऐसा झंडा फडका बन गया अब तो ऑफिस मे मैं सबसे smartest लडका...

[@Innozant]

Hahahaha.. Lovely ❤️ Yahi reviee Google review par daailye..it's lovely ❤️❤️❤️☺️

[@shrijara3054]

Hi Sir, Thank you for the wonderful explanation. ek question hai, what if two different products have same amount. Vlook will fail here right? Is there any alternate here in such scenario?

[@ManishVerma-gg8xl]

गुरुजी बहुत ही काम का तडका है अब तो आफिस मे रोज लगेगा और इसकी महक दुर तक जावेगी 🙏🙏

[@Innozant]

👍❤️

[@newgadgetsland1368]

5 star from Pakistan, most exquisite video

[@Innozant]

Thanks dear... happy Learning ❤️

[@AnuragSingh-w7g]

useful trick सर 👍

[@sandeepaswal8944]

Thank you so much Sir for making life easier with sharing such a wonderful tutorial.You have explained very clearly and to the point.

[@Innozant]

Thanks Sandeep Ji,Hope you are learning and enhance your skills everyday.

[@gaminglover262]

when i enter new entry so those who I'm create a second table entry are able but some data is deleted automatically so any one tell me what to do

[@dtonagpurrural9526]

Data Entry with Auto Sort | Ascending or Descending order me agar same value hai to for exampale 4 row me same value zero hai to fourmula kaise use kare

[@mukhbiir2567]

Sir aapko to bahut knowledge hai and thank you for providing free knowledge.

[@Innozant]

Thanks Mukhbir Ji,Hope aapne video se seekhna start kar liya hai,Keep learning and get motivated everyday.

[@mukhbiir2567]

@@Innozant sir aapki ye baat acchi hai ke aap reply karte hai na ki baki youtuers ki tarah

[@Innozant]

Step by step seekhiye startse. From Basic Excel Playlist.Aayega samjh aisa main umeed karta hu.

[@nirmalrana9439]

Very nice... I needed it

[@totalhyper72]

Respected sir, Your way of guiding is so nice Very much simple like friendly and easey to understand. Straightly as to the point. Superb sir 🌹 👍 🌹

[@Innozant]

Thanks dear ❤️

[@totalhyper72]

@@Innozant my respected, I request to you for a solution To sort a file with thousand numbers , irrelevant to me or my office. I want to select related to my office Here is thousand numbers with this code 12236 12254 12241 12245 12246 12247 12236 From these I just want to filter & select data releted to my office With this code 12241 , 12245 only Please

[@rewawaleashu1554]

Very nice class sir

[@maheshnagvekar5182]

Thank you so much for this video

[@personrid9433]

I would like to use the information in the field. "Ahmount" is a time number, for example 03.10.59. What should I do? Please advise.

[@KvNarayana-gh8ug]

This video is useful but one problem that is two or more items with same value only first item is reflecting against four items. Is there any trick to rectify this. Please tell.

[@omkarchimbalkar5912]

Very nice teaching sir

[@Innozant]

Thanks dear

[@sunilyadav4]

Same Amount repeat hone par Product id 2 baar aa raha hai

[@anisulhoquechowdhury7873]

Thank you boss... Could solve my problem partially viewing ur video. In a football League if 2 teams have same points, then ur formula shows same team twice. So, my query is...if points r same, then ranking will apply on goal difference... Could u suggest any formula???

[@deltagaming7927]

hii sir ek value 2 bar aata he to thik se kam nahi karta he plz help me

[@Techmava2]

Thank you bhai for index formual

[@shrikantbadge3978]

thank you sir

[@priyankabhineet2715]

Namaste Sir, Please guide what to do if 2 or more product ID has same Amount. As I am using this formula, I had 4 different product ID with same amount, and this formula was returning me same Product ID for each same Amount value. By the way, you are the best teacher for excel. Your videos are very informative and at the same time very intresting. Sometime i just watch for intrest and parelally learn information. Thanks sir🙏🏼🙏🏼🙏🏼

[@waleedalqubati3849]

Thanks dear

[@IITASPIRANTS]

if same number appear in the amount column, then how it works. i mean if amount is same for two different invoice numbers?

[@satscoolstyle4210]

Agr column mai common count h kafi saare to dependent column kese pick karege

[@wahidrashid4865]

Sir very beautiful

[@anooparora2515]

Thanks

[@shivprasadmishra268]

Sir if amount is repeated then index formula will fetch first occurance in both amount suppose amount is same in two invoices then 2nd invoice missed.

[@HarshwardhanChouhan]

Why have we used vlookup(large) when we can directly use large function there.

[@uniquemobiletipstricks7714]

Lekin lookup value ki limit hoti h 255 charcter kya ye sahi he

[@pratikvirani1353]

hello sir , isme ahar amout same ho to invois id bhi same ho ja rajaje , to uska kya solution he

[@PawanKumar-nv8tb]

Hello sr AGR horizontal mai kese niklnge ascending aur descending mai

[@fantronicsable]

Thanks Bro Very Good Presentation

[@Innozant]

Thanks Dear❤️❤️🙏

[@totalhyper72]

Great , so nice

[@tejpalsain1507]

Thanks for practice file.

[@OnamicaKhatun]

When I am trying to input duplicate or triplicate amount in column C then in column 'F' it shows duplicate or triplicate data. How to solve it ?

[@naeemahmedpirzada9255]

Amazing sir

[@Innozant]

Thanks Naeem sahab ♥️

[@archana8825]

Sir agar mujge 70 se jitne bhi number hai maximum pta lagana hai kitne hai toh kis formule la use karenge

[@kishorekumarbiswas3911]

Sir, I want to short the Name(as per my database) to assending order (only name column) what I will enter day by day, plz help me.

[@monikakarar635]

Thanks a lot

[@Innozant]

Thanks Monika. Keep Learning and Keep exploring

[@itsmesujoy9351]

Agar 2 amount equal hoga to isme problem ayega

[@jigar6007]

thank you

[@Innozant]

Thanks

[@nehaagarwal5410]

How to check condition fulfillment only once in excel. If the condition is true one time then stop checking condition again. Please Help

[@ravijeetsinghchhabra6701]

IF TWO VALUES ARE SAME, THEN IT WILL NOT REURN THE CORRECT NAMES...PLEASE SUGGEST

[@addnew2448]

Sar agar taxt ko sort karna ho to kya karenge.?

[@animals-video261]

Just say wow👍

[@grandpasaysrelax175]

superb!!

[@azimbihari]

good

[@santhoshkumarsm6422]

Nice sir , really good explanation. Sir here i want to make a bar graph in excel which should show big bar for small value , and small bar for big value, kindly inform me if you know about it ...

[@Innozant]

Need to customize your formula befire applying bar graph

[@yourchannel6024]

Weldone

[@sumankumar7215]

Great👏

[@akrantikuta4500]

Sir ek date se doosre date ka drop down list aur us dates data Nikal kar aye please batao

[@zainulabiden3172]

Sir isma 2 table hn hamare pas tu kese krenge

[@arunkumar-hr9ve]

If same value exist then what would be

[@tejpalsain1507]

Super trick sir

[@Innozant]

Thanks Tejpal ji for wonderful feedback

[@naeemkhan-tm9hx]

Nice video

[@harivanshgautam3424]

Nice video sir. It can be interview question also, I think.

[@Innozant]

Yes dear it's interview question.

[@xixi2693]

Sir in excel sheet i want cell B(old)=B(old)+A(new) in cell A data is coming form website in real time cell B i want to retain its old data and go on adding new data from cell A ,in same cell B

[@amlanmukherjee7041]

what is the use of vlookup?? simple large function along with index will make the same result I think so.

[@Innozant]

Hi Amlan Ji,kindly use it with and must see the difference why i use that🙏🙏♥️

[@VikramKumar-du2mw]

Nice sir

[@ZyberOne]

Hello Teacher I have a problem when my value data number are the same.

[@Innozant]

Hi..Ask your query dear..will give you solution for the same.

[@napsterdescent]

Same value rehne par 1st name ko hi bar bar repeat kar raha pls help on this

[@Innozant]

Us nake ka occurance jitni baar h wonshow krega

[@rabikantverma9770]

thanks for the video bahut useful hai sir ......but ek dikkat aayegi...yahan to sari values alag hain.....to baat nhi.....but Mere data me to sorting values same bhi hoti hain......then what to do....just like assending order me set Kiya data ko but do baar 100 aa gya taab match me name kese lega.....RABI=100 AND SOHAN=100

[@rabikantverma9770]

Sir sawal ka answer to do....malik

[@rabikantverma9770]

Me ek 22-23 ke liye ek format ready kar raha hun

[@rabikantverma9770]

Usme jarurat hogi mujhey

[@srinivasgoudmanthapuri2719]

Very nice explanation with simple language....👌👌

[@ranjanverma1]

Mai excel me sort karta hu to 10, 1 k baad aata hai proper me kaise hoga. Ex A-1-R-1 A-1-R-2 A-1-R-3 ... A-1-R-10 A-1-R-11 A-1-R-12 Sorting problem A-1-R-1 A-1-R-10 A-1-R-11 A-1-R-12 A-1-R-2 A-1-R-3 ऐसे आता है

[@gauravbhatia7987]

Thna sir very much

[@Innozant]

❤️❤️🙏

[@naeemkhan-tm9hx]

Kindly, upload use of macro...specially use of relative reference

[@Innozant]

Thanks Naeem for suggestion to upload use of Macro,Soon you may able to see a Playlist of Macro In detail.

[@naeemkhan-tm9hx]

@@Innozant thanx

[@uzzal44976]

Sir, I hope you are well .if 3 type of amount column, such as 3 type of amount column C 500, D 300, E 400 & F Total 1200. How can ? Uzzal from bangladesh.

[@Innozant]

Use sumproduct to achieve this

[@jaspalrana9541]

Nice.

[@Innozant]

Thanks Jaspal Ji

[@narressh2196]

Hello I have a query would appreciate your help, I have a data in Excel where I don't have to sort ascending or descending order but only check the data if it's in ascending or descending true or false, thanks

[@Innozant]

Pass the condition to check either dAta is sorted or not.You just want to show true or false there in front of data?

[@narressh2196]

@@Innozant yes, how do I do that

[@sunilsivanl]

if same amount comes, how to index

[@Innozant]

What's prob in that?

[@tejpalsain1507]

नमस्कार । क्या हम excel में जन्म दिनांक को शब्दों में कन्वर्ट कर सकते हैं । जैसे 25-07-2015 को पच्चीस जुलाई दो हजार पन्द्रह।

[@Innozant]

Kyu nahi..without VBA funcation ke through bhi aur with VBA dono tareekese kar sakte Hain.Jald aayega video tips and tricks playlist me

[@tejpalsain1507]

Thanks sir

[@darshak_khunt]

data me same value hogi tab sort nahi kar payega barobar se otherwise ok chalega

[@deltagaming7927]

sam amount 2 bar aati he to sahi nahi chalta sir plz help me

[@Innozant]

repeated value?dono ko saath me show leega ..issue to nhi aana chaiye

[@jarurijankari7352]

Esme sem amount hone par ye kam nahi karega sir ji

[@Innozant]

Kya same amount hone par..kindly explain?

[@jarurijankari7352]

@@Innozant ha

[@YOGESHSAHU-kc6gu]

सारा एक जैसा अमाउंट होता है तो वह गलत एंट्री करता है एक ही नाम को लेता है

[@R_K_ENTERTAINMENT]

But if two or more values are same

[@Innozant]

Tab nhi sort hone me koi issue nhi hai dear.Thanks for showing your interest and start learning

[@R_K_ENTERTAINMENT]

@@Innozant but sir name wale field me first name pick kare ga agar do value same too then rank function kese use karege Plz give example

[@Innozant]

Iska already video hai.New Rank formula.Yadi duplicate value Hoga to..Aap basic excel playlist me Jake Rank Ka video dekhiye..Concept clear ho Jayega Aapka.Thanks.

[@R_K_ENTERTAINMENT]

@@Innozant VLOOKUP(LARGE($C$135:$C$141,A139),$C$135:$C$141,1,0)and =INDEX($B$135:$B$141,MATCH(E140,$C$135:$C$141,0),1) sir where to use rank function

[@Innozant]

Rank pehle alag se nikaliye if duplicate value is there..Uske baad function me concatenate kijiye use.try kijiye.nhi HOTA hai then let me know

[@mohitchauhan7808]

👍👍👍👍👍

[@Innozant]

❤🙏

[@deovritchauhan9006]

Sorry excel sheet not see clear.

[@Innozant]

It is fine..kindlye watch again

[@dishadeepbanerjee8548]

Value same rahe to dikkat aari uska solution dede

[@Innozant]

kya issue face kar re h

[@dishadeepbanerjee8548]

Agar mera frequency same h column m to wo ek hi value dikha rha h arrange hone k baad

[@manologelatoicecreamlahore9712]

Dear How can i download this sheet (Data Entry with Auto Sort | Ascending or Descending order |Excel Magic Tricks) Have you any whatsapp Number?

[@Innozant]

Zawar already downloadable file limk diya gya hai video description me..kriyw download aur practice kijiye ,koi prob aata hao to jaroor batayen

[@Justsimple-123]

sir itna complicate ku kr rhe ho ........... 2 bar aap ki vide0 dekhi khuch samaj nhi aaya

[@Innozant]

It's not complicated .. conceptually learn kriye aayega samajh...bht aasam solution chaiye to sort function use kar lein

[@tejpalsain1507]

It's very helpful sir.

[@Innozant]

Step by step seekhiye..startsr..from basic Excel playlist..aapko jaroor kuch naya milega seekhne ko

[@tejpalsain1507]

जरूर सर । आपके वीडियो आसानी से समझ में आते हैं। और इनसे हमे बहुत मदद मिलती हैं। आपका बहुत बहुत धन्यवाद।

[@sanjaygupta-qj3ym]

Awesome sir

[@Innozant]

Thanks Sanjay ji🙏❤️