"Unbelievable Excel Trick: Flash Fill Can't Handle This Challenge!"

In this video, I will us a unique and effective method to extract 6-digit pin codes from an address column in Excel using a tricky formula. Forget about Flash Fill! This trick will streamline your data processing tasks and enhance your Excel skills. because I have used, Len formula, Mid formula, Match formula and sequence formula of excel to get this.
🚀 What You'll Learn:
How to identify and extract 6-digit pin codes from a complex address column.
Step-by-step guide to creating a powerful Excel formula for this specific task.
Tips and tricks to improve your data management efficiency.
#Excel #ExcelTips #DataProcessing #ExcelFormulas #FlashFill #exceltutorial
👉 Challenge for you!!!, Ye video me jo practice file hai mai de raha hun usme address me pincode hai use alag karna hai kudse try kijiye nahi solution mila to yahi video dekh lijiyega, PRACTICE FILE :
drive.google.com/file/d/1EW3Q...
Excel 2016 aur Older version hai to unke liye ye formula hai : =MID(A2,FIND("@@@@@@",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,1,"@"),2,"@"),3,"@"),4,"@"),5,"@"),6,"@"),7,"@"),8,"@"),9,"@"),0,"@")),6)*1
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
For Short tips : / @skill-course
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more_pro
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My RUclips Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

[@Learn_More_Pro]

👉 Challenge for you!!!, Ye video me jo practice file hai mai de raha hun usme address me pincode hai use alag karna hai kudse try kijiye nahi solution mila to yahi video dekh lijiyega, PRACTICE FILE :
drive.google.com/file/d/1EW3QGFVq86cLMjZo2eIn8tYa3fxxdiLK/view?usp=sharing
Solution mila to comment kijiyega aur Excel 2016 aur Older version hai to unke liye ye formula hai : =MID(A2,FIND("@@@@@@",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,1,"@"),2,"@"),3,"@"),4,"@"),5,"@"),6,"@"),7,"@"),8,"@"),9,"@"),0,"@")),6)*1

[@friendly8342]

Sir me zero se Microsoft Excel to advance level ka Excel ek hi course me Sikhna h so which course to buy

[@vikramraj1464]

सर कंपनी में कौन-कौन सा काम आता है और कैसे होता है, यह सबके बारे में वीडियो बना दीजिए सर।

[@rahulvishwakarma2119]

=Aiextract(data,"pincode")

[@ambikamaurya2601]

Hello sir, I just came here after getting my Excel beginner to advance course Certificate 🎉😊 Thankyou so much for your guidance . Best teacher ever!! ✨️

[@arunkumarsinghark3024]

🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l

[@asmrindia]

Very Nice Sir
Thanks

[@darshitchavda8264]

What a logic sirjee.... awesome.... & Excel booster

[@hellodaraihiya3670]

Thanks sir 🎉❤

[@thepintuvlogs]

Thanks sir ❤

[@TechnoEveryday]

Jabardast🎉🎉🎉🎉

[@Harshsanjana]

Explanation is good

[@vikramraj1464]

Thanks sir ji

[@balwantswami704]

Jai ho Gurudev, Very well explained

[@nil_auto]

Good 👍

[@romilbari9673]

Excel booster 💥

[@muhammadumairakhtar5177]

Bahut khoob

[@sachinkale4544]

intresting

[@sushilprajapati200]

this is very best

[@khanarif2562]

One of the best teacher of computer specially for Ms office love ❤ from Pakistan

[@Adityasshenoy-rw4ox]

I want to learn about Excel booster tool..sir ❤

[@smmexp9]

of course you are excel booster🚀

[@bhokaltoligaming3123]

Excel Booster 💪

[@susovonnath2654]

We can use AGGREGATE function instead of MATCH. =AGGREGATE(14,6,MID(Table1[@Address],SEQUENCE(LEN(Table1[@Address])),6)*1,1)

[@user-xs5fb6nx2m]

thank you sir satish dhawala ,,,,,,,,, ( irfan butt ) love you from pakistan ,,,,,,,,,,,,,

[@emmi.x]

Hello sir
Please give me some solution, in my Excel sequence functions not available. What should I do, to use this function in my excel

[@rakeshanb2464]

@learnmorepro sir I can't able to find the extract formula to copy please help me out sir

[@acieducation6401]

Sir tarike se kya kya hum khuch bhi alag kar sakte hai

[@vikramraj1464]

Sir company mein कौन-कौन sa kam aata hai aur kaise hota hai yah sab ke bare mein video banaa dijiye sar.

[@toxic9689]

Excel booster

[@irfanshaikh5577]

Excel Booster ✈️✈️

[@adepukrishna]

Xl booster
🎉🎉🎉🎉

[@maheshkaushik1722]

Kuch pincode number agar 99999 se kam hue toh and kuch jyda formula mein kya change karenge

[@N_H12345]

Excel booster Video required

[@SmileCartoonZone]

XL booster in want 😍

[@friendly8342]

Sir i want to learn POWER BI zero to advance level but you didn't launch power bi course tell me how can I learn POWER BI by you

[@soumenmalik8888]

Xl booster review

[@asifalipinjara3840]

Python par video banaye

[@jhonnydeppfan4370]

XL boost

[@arunkumarsinghark3024]

Excel booster chahiye

[@CRICKOOT324]

Sir mene abhi abhi aapka 99 Rs. Wala course purchase kiya hai ... But muje kuch doubts clear karne hai ... Muje thodi si problem aa rahi hai course me and helpline number lag nai raha ... Kindly reply me 😢

[@altafamirali4946]

XL Boost

[@tuniqueonlineshopofficial]

XL booster

[@lokeshdasariya1111]

sir, what if pincode is 5 digit??

[@emmi.x]

Where is the code for extractpincode function?

[@The_Stories_1M]

Excel Booster

[@nancy97663]

Excel booster ?

[@EktaAggarwal-tj9sp]

Xl-booster

[@rakeshanb2464]

xl booster

[@salimullah7117]

Convert date to Urdu word in excel....

[@harishsharma7721]

XL Booster

[@rohitindian9502]

Xl booster

[@gopalparmanik6708]

Mujhe client address me bhi pincode deta hai aur alag se row me bhi deta hai, mujhe address se pincode remove karna hai with text "pin code" "pincode"

[@mdsarfarazalam8432]

Extract pincode de dijiye

[@nabinmandal631]

Sequence is not working in my excel

[@EktaAggarwal-tj9sp]

El-booster

[@ahilkhan77]

Excel ka naya course lao sir

[@vssgaming7563]

Excel tools

[@mdsarfarazalam8432]

Sir extract pincode file dijiye

[@vssgaming7563]

Excel postur

[@mdsarfarazalam8432]

Extract pincode work nahi kar raha hai name error aa raha hai

[@vssgaming7563]

Excel Postery

[@ravitalhar124]

Excelbooster

[@vssgaming7563]

Excel postor

[@sachchidanand5952]

Xl Booster

[@Villager_art]

Yi maira drawing ka channel hain

[@rohitkusbhage4394]

Too much complications

[@mjmovies5364]

xl bost

[@YoutubeThumbnailDesigner]

My Thumbnails

[@pradeepkumarahirwar6619]

समझ मे नही आया लेकिन कोशिश करते है समझने की

[@mdsarfarazalam8432]

Woh aapne Diya he nahi aapne to bataye de dunga send kar dijiye please..

[@abhinavvlog7451]

Excel boster

[@rahulsinghrautela2919]

Xlbooster

[@shibuadak7419]

excleboostr

[@shamabano8024]

Sir hame aap ke institute per ake course karna please contact num

[@prafulsheraji4434]

Hello sir, very nice explained and superb formula designed.
I also have one query
I am working on inventory report with Adani Group.
In YTD Report there are so many calculations and confusions.
I can share datas and logics on email address.
Please share your email address

[@ShaunakShah-ln4yn]

Excel booster

[@rajeshmahabal4397]

XL booster

[@ANSARIAFZAAL]

Excel Booster

[@nirupammishra7434]

xl booster

[@SparkVision1]

XL Booster

[@manishkumaragrawal1278]

Xl booster

[@Ami-vw7bw]

Excel boster

[@khanawais5154]

Excel booster

[@nirmalbehura9039]

Excel booster

[@kishorpanara4191]

Excel booster

[@manojchavane3650]

Excel booster

[@durgeshmourya3226]

Excel booster

[@omtiwari6442]

Excel booster

[@maheshkaushik1722]

Excel booster

[@Rameshkumar-rf6gc]

Excel booster

[@prasadgaonkar5815]

Excel booster

[@ALLINONE-fz5bb]

Excel booster

[@earningablebybiraj3243]

Excel booster

[@pinkitiwari7423]

Excel booster

[@monishkhan3732]

Excel booster

[@suhashjar1211]

Excel booster

[@AbhishekKhare-ty6yb]

Excel booster

[@ryjn6529]

Excel booster

[@aqeelawan8634]

Excel booster

[@tunabehara9884]

XL booster