Flash Fill in Excel | Time Saving Excel Flash Fill for Data Cleaning Tricks in Excel

[@sandeepaswal8944]

नमस्ते सर जी | आपने आज 9मिनट के वीडियो मै बहुत ही deeply समझा दिया | आज मुझे Flash Fill से नई नया सीखने को मिला | आपने जो empty cell & help Flash Fill To see सिखाया मजा आ गया मुझे | और लास्ट मै Flash Fill does not recognize change in source data ,but formula do. ये भी नया सीखा | सर आपका बहुत बहुत धन्यवाद आपने Master Practice Folder All Playlist प्रदान करी अब मै और अच्छे से प्रैक्टिस कर सकता हूँ |

[@rashmi2848]

Sir your teaching is in high level sir . Tq 🙏

[@hamzanasir4492]

Sir Love You From Pakistan ❤

[@shivpoojantiwari2683]

Your motivation and advise is absolutely fine

[@Innozant]

Thanks Shiv ji

[@anishbiswas8546]

Your are best sir

[@abhishekjadli1566]

Great video sir... Great Posing in the Thumbnail😄

[@Innozant]

haha..Thanks for appreciation dear

[@poojagahlot105]

Thank you bhaiya! bohot achhi trik batayi apne.

[@Innozant]

Keep learning

[@manishkumarkumar4547]

Excellent

[@umeshautade8458]

Most informative video 👌👌👌 Nice sir 🙂

[@Innozant]

Thanks Umesh Ji..Happy Learning.

[@AllahDitta-gp5lt]

جزاکم اللّٰہ خیرا کثیرا کثیرا

[@rinturoy8014]

amazing video

[@neerajkhurrana283]

Nicely explained sir, thanks 😊❤

[@nanjundeshwara-593]

very very fine

[@hsgusain2054]

Thanks Sir. For sharing knowledge

[@Innozant]

Thanks Gusain sahab

[@dhakafady774]

thanks a lot , sir

[@cartoonloversop6019]

Excellent topic Realy time saving tools Fantastic

[@Innozant]

Thanks dear ❤️

[@arunkumarsinghark3024]

Superb sir

[@virendersroha1754]

Aapbhi hmare leye god ho Excel k srji

[@harivanshgautam3424]

Sir, You perfectly differentiate the usefulness of a formula and a flash fill. Nice video.🙏

[@Innozant]

Thanks Harivansh Ji.

[@hyperboy0001]

@@Innozant sir jaise single 4 name hai Ram kumar Amit mishra Vicky Rahul arya Inka hum first or last nikalna hai to agar hum kr rahe h to single name Vicky ki jagah last name. M Vicky likha aarhA hai blank nhi aaraha esa kyu sir

[@jatinsharma5024]

@@Innozant sir then why we need ( Left , Mid , Right ) formulas then if we can do job so easily with flash fill

[@Innozant]

@@jatinsharma5024 Flash Fill and Text to column is used to speedup your productivity at office but when you are sitting in front of interviewer they are interested to check the conceptual and logic building skills therefore no replacement of Formulas and Functions.

[@jatinsharma5024]

@@Innozant Yes and also if there is a change in the source data , Flash fill will not change the output but Formulas will. Am i right

[@mohammadghazanfarraza7814]

Hello Sir Main Aap ki KZbin video dekh hai aap ki explanation bahut achchi lagi aur aasan vii .....sbse bri Baat aap jo vii Vedio Banate hai Usse aap previous class me jo sikha tha usse vee aap New Video Me cover krte hai.... Previous class Ko New Class me Compair vii krate hai .. Deference pta chalta hai.... Jo Bahut Achchi hai.... Sir Mai Chahta Hu ki Aap New Series EXCLE Class ki Start kre jinme EXCEL Me Jitne Vii Option Hai or Formula And Tab Sb ko Explain kre. Kyse Sb ka used Krna hai Sarii Option EXCEL ki. Besic to Advance Level EXCEL_SHEET me jitne vii Option Hai or Formula And Tab Function sb ko.. Plz Sir...

[@Innozant]

👍❤️

[@yogeshtawade2112]

Nice sir

[@Innozant]

Thanks Yogesh Ji🙏🙂❤️

[@AllahDitta-gp5lt]

Thanks u sir

[@teenasehgal1982]

My favorite hai...flash fill

[@rakeshmlearningentertainme6099]

aswsome video sir ji

[@bhoopendraraghav9781]

Thanks sir nice video

[@amitpyasi2819]

Sir office 365 Mai flash fill ki kya short cut key hai

[@gauravbhatia7987]

Good sir

[@Innozant]

Thanks Gaurav Ji.❤️🙏👍

[@sonukumar-xp5sd]

Genius

[@amitpyasi2819]

Sir office 365 Mai available hai ki nahi

[@shubhamjaiswal1513]

SIR BATANA CHAHUNGA KI AB FLASH FILL MEIN BHI POWER QUERY K HELP SE AUTOMATE KIA JAA SAKTA H YAANI YE JO ENJOYMENT H AB PERMANENT H

[@shwetkumar1719]

Sir kya hm ek bar Array formula pass krne ke baad fir se usko edit nhi kr sakte hai??

[@Innozant]

Kaunse ki baat kr re h..flash fill ka usne ya array fornula.?

[@shwetkumar1719]

Sir Array function me agar hmm ek particular cells of select kr ke ctrl+shift+Enter kr rhe hai to sb ka same value q a rha hai

[@Innozant]

Ek saath select krke phir array formula use kijiye then ctrl shift enter

[@Mummy-es2zc]

Sir pls mention specific folder name of this video file

[@nitrogaming3188]

2:07 sir apka initials wala galat aaya h sahi ke liye "AM" ke baad niche dubara ek Row mai likha hoga sahi tab ja kr vo samajh payega pattern

[@Innozant]

Video bnate time flow me pattern nhi diya hoga maine..kindly rectify the same

[@umeshautade8458]

Can we enable and disable flash fill in worksheet or can we restrict user from using Flash fill? If yes, can you please explain.

[@Innozant]

Yes you may enable or disable it ,File-options-advanced -uncheck flash fill

[@umeshautade8458]

@@Innozant Thank you Sir 🙂👍

[@swagatamkhanra4667]

Sir flash fill dynamic ho sakta hai?

[@Innozant]

Dynamic kehne se mtlb aapka😚it works as recorded macros

[@swagatamkhanra4667]

@@Innozant yes sir agar source data ko change kare to ye apne ap change ho jayga automatically?

[@Sayeef_Khan]

Love from Bangladesh. Subscribed to your channel long ago. In this video, all I could do is give you a like. I would you a cordial Hug as respect If I had found you face to face

[@Innozant]

Thanks Sayeef .. Really means a lot to me.👍❤️

[@neerajtomar9018]

Sir kya excel 2007 main bhi kam karega??

[@Innozant]

nhi dear 2013 me

[@Amit_Kumar_Trivedi]

It is not picking the initials correctly in the top most dataset.

[@AlimKhan-bl5sh]

Sir initial ki value jab apne nikali to aman ka A or mathur ka M to agaya tha lekin niche wale kii sab value galat ayi hai apne shayad dhiyaan nahi diya..

[@motivationalshayarisneha1210]

sir ctrl + E se drack nhi ho rah hai

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@amitpyasi2819]

Sir flash fill not available 2007 excel

[@Innozant]

No ..layest verion m.hain dear

[@pawanwakale8801]

Sir mai yeh topic practise kar raha CTRL+E par nhi ho raha humare excel me ,

[@Innozant]

Kaunsa office version use kar re h..office 2013 onwards milega

[@pawanwakale8801]

@@Innozant mera 2007 office hai

[@pawanwakale8801]

@@Innozant sir best office konsa hai jisme sabhi function work karte ,,kyoki ki kuch kuch function nhi hote work bich bich me , Suggest karo , aur hum ek sath 2 office use kar sakte kya PC me

[@pramodbhatt6906]

SIR WHAT IS REVERSE?? I THINK OUTPUT COMES WRONG IN YOUR SHEET IN EXAMPLE 1

[@Innozant]

Kindly check it and apply again

[@arunkumarsinghark3024]

Sir, मेरे पास कुछ Excel data है, हमे रोज replace formula लगाना पड़ता है, please please please guide me sir, उस data पर कैसे flash fill use कर सकते हैं l

[@Innozant]

Flash fill kisi bhi data par chal jayega..apko data pattern pass karna hota hai bus

[@satender7625]

❤️

[@PawanKumar-lc3du]

sir ji reverse order theek nahi hua, please right formula batayia

[@Innozant]

Kya issue ho ra hai?

[@PawanKumar-lc3du]

@@Innozant aap video dek lo aap ko pata lag jaayega ya phir excel sheet check kar lo

[@Innozant]

Kaunsa video dekhma hai.?aap apni querg likhen ek baar kya out put chahte h

[@PawanKumar-lc3du]

@@Innozant flash fill video may reverse order theek nahi hao

[@Innozant]

Ok..reverse again krke dekhiye flash fill use krke ek baar

[@mohammedabid3731]

Is this work in excel 2010

[@Innozant]

No Ms office 2013

[@fsgaming6850]

SIR FORMULA kam nhi kar raha

[@Innozant]

Issue ?

[@fsgaming6850]

@@Innozant First of all Thankyou very much sir for replying Sir the problem is jo mein aap ka data use kar raha hon or same wohi formula laga raha hon but answer nhi a raha

[@fsgaming6850]

Sir formula work nhi kar raha sub kuch sahi pher bhi

[@DEADYBOYS]

Hello sir video me mistake hai reverse sahi nhi hua hai video check kariye please create new video with unique new tricks 😀

[@Innozant]

Reverse me kya issue aaya..aap khude krke dekhiye ek baar...everything is working fine

[@DEADYBOYS]

@@Innozant please sir check it video reverse aap se bhi galat hua hai video me please check

[@Innozant]

@@DEADYBOYS Dekh liya maine..Kabhi kabhi flash fill sahi pattern nahi utha pata hai,wahi issue hai,aap dubara apply karen..its working fine

[@tarjitmalka3978]

🌟🌟🌟🌟🌟

[@geetanjaligupta828]

Initials galat hai

[@Innozant]

First name ka 1st char aur last name ka first char..👍

[@subhasisdey4315]

bolne ka style acha nahi hai

[@Innozant]

Ok...wo to mehnat karke theek kiya ja skta hai..Thanks for suggestions..Noted ❤️