#Shorts

#Shorts | Advance Filter Hacks | Only 1 % Excel User Know | Excel Tips & Tricks
#shorts
#advancefilter
#gyaniabhijeetji

[@GyaniAbhijeetji]

join our courses👇 lmech.courses.store

[@santabajra5326]

Its works only when all list are in same order number as in master file ..if serial is jumble its not work as vlookup

[@shyamlambe4411]

index+match function से भी होता है ।

[@GyaniAbhijeetji]

Yes excel has multiple tips and tricks to get output it's totally depend on your requirement

[@dhaker_vinod_1998]

Index match mst hai😎

[@dixitvyas4027]

Great information

[@pravintalokar2534]

Ye koi formula nahi hai ye searching tool ki tarah kaam karata hai. sirf copy paste hai isase exact result nahi milata vlookup sahi hai.....

[@omaspvtltd-hw3mb]

Bhai vlookup drag karne se kaam nhi karte lock bhi Karlo to bhi

[@StechEarnings]

​@@omaspvtltd-hw3mb Karta hai bro Agar nahi karta hai to copy select all and paste ❤

[@gamingvideo261]

​@@omaspvtltd-hw3mbto aapko vlookup aata nai he abhi tak

[@RishiPradhan-kf1cr]

@@omaspvtltd-hw3mb Main table ko "define name" karke karo kaam karega

[@Global_Forums]

Excellent

[@morsheddld]

Good, new for me

[@akash_k_kumar272]

Yar bhot gjb btaya sir 🤟🤟🤟🤟🤟TQ so much 🙏🙏🙏🙏

[@m.kmukeshstatus1369]

Thank you sir

[@user-un5bb1df5e]

Life saviour trick

[@santabajra5326]

Great 👍 👌

[@beingfahad9242]

It's very useful video for me and new also ☺

[@GyaniAbhijeetji]

Grt keep in touch and learn more

[@shivsharanrmadachane3217]

Thanks 🎉

[@abhimanyupundir6543]

Super job

[@VijayPawar-sz6gq]

👌

[@harendrakumar4292]

Sir index match ka bhi btao formula

[@JKLIFESTYLE.07]

Nice bro ❤❤❤❤

[@BHARDWAJPSONI]

Dono sheet me data same sequence me Hona chayie.. Is it true? Becoz I think it's working like that only

[@Sushilkumar-jm7mj]

Thanks

[@durjodhanmontra8501]

Thanks boss

[@JITENDRAKUMAR-bm7ss]

Great information sir

[@GyaniAbhijeetji]

Thnks

[@atanuroy3548]

Advance filter aur V lookup hum dono hi istenal karte hai.Jab jaha jiski jaroorat pade.

[@desifunincanada]

Very nice

[@davidpani7743]

Nice trick

[@InternalitProspecta]

Thank u for the amazing trick

[@GyaniAbhijeetji]

Wlcm

[@subratadas1705]

Really amazing ❤❤Bossss Thank You 😊❤

[@Hamare_Youtubers]

index with match kesa rahega... isme

[@SahilGupta-tz7tp]

ISME VLOOKUP KESE USE HOTA

[@kanchanvishwakarma9461]

Time to vlookup jitna hi lagega na

[@aakashmittalmittal8688]

Nice

[@aashi__0924]

Good

[@MIBGAMINGYT0.3]

O Bhai control plus kaise dabau mein

[@viralvideo6487]

Wa😊

[@Ishantbhatnagar777]

Ye only sequence mein chalta h

[@Riyavlogs_24]

Nice but u should also tell where not to use this

[@prabhatsingh3305]

Sir, Data set bhi share kia kre toh practice bhi ho jaye

[@GyaniAbhijeetji]

Ok

[@Suresh_Suri.]

Wow

[@LearnWithNeeraj123]

Ye tarika use karna galat h, Kyoki agar hm apne master data me kuch change krte h ,to yha par change nahi hoga, jbki agar hm vlookup use karte h fir agar master data me kuch bhi change kro, yha Automatic change ho jayega ❤

[@TashuRaj03]

Pankay aur pushkar ka salary increment karado

[@techbhifactbhi]

Bhaiya ek file me se dusri file me data dhundna hai vo kaise dhundhenge please batao please help

[@sumitlima9507]

👍

[@forkkgaming2740]

Index + match

[@neehasolkar5292]

Agr employe id sequence mein hai to hi data sahi fill hoga warna uper niche hota hai

[@GyaniAbhijeetji]

Sequence not matter but lekin isko apply karne ke bad ye dynamic nahi Higa agar aap koi value change karti hain it will not fetch from there it's totally depend your situation

[@alfiappimohammed416]

good bro

[@ManiTechCircle]

What version office used by u ?

[@sparrow66188]

mai socha tha ki aap index match use karoge

[@walidurrani191]

لیکن پور ماسٹر فایل کی انفارمیشن شو نہیں ھوا

[@AloneTech9871]

Bhai advance filter ka use karenge too aagar original table a kuch change hua too aapke other files me koi update nhi hoga isliye vlookup ka zayada use karte hai

[@GyaniAbhijeetji]

Yes advance filter mein chise dynamic nahi hongi us condition mein formula sahi hog

[@SHAKEELKHAN-yy1xz]

It's now working, can you please guide

[@kanha_ji_video]

Thank you

[@GyaniAbhijeetji]

Wlcm

[@kalpatarunayak5619]

Data not come according to empid ...if we change order

[@GyaniAbhijeetji]

Yes u r right if your requirement is that data sequence need to change then you have to use vlookup It's totally depend on your situation But after apply this Tricks copy all the data and paste it as paste Special values then apply filter

[@BMT007]

in filter case this formula doesn't work so pls any1 using this formula don't use on data which is in filter mode

[@GyaniAbhijeetji]

Yes

[@zeetahwrites1640]

Vlookup bh muskil ni😊

[@LaughtLagoon]

Sir copy paste bhi toh kar sakte the

[@sudhirsamueltoppo7576]

Amusing..very well done sir 👏.. please teach me more..

[@ashish90702]

WHAT ABOUT XLOOKUP ??

[@SiddharathSharma-]

Bhai fayda kya hua maine 2 ki jagah 1 likha 1 ki jagah 2 snooze accordingly nahin bas makkhi picture makkhi mar di

[@RishiPal-hs5uf]

Gjb

[@zeetahwrites1640]

Agr dusri sheet pr ho to

[@vudayreddy]

its working only for 186 lines in list

[@muhammadkhalid9188]

There is no data extract..

[@manoj28]

Practice file kaise milegi sir

[@GyaniAbhijeetji]

Practice file to abhi nahi hai aap type karke same data prepare kar lo

[@MIBGAMINGYT0.3]

Control a aur bi dabane se ho jaega

[@heartpirates-qt6ws]

Yarr dget use kar langa

[@azizurrehman6296]

How i Can use the same excel version that you are using.

[@kingvishu601]

There is a way. This is also a nice video. #learnwithvabs

[@anilkumarsharma8901]

Bot banvaney ka kya letey ho???

[@vishalpandey6336]

ITNA BHI UNIQE NHI HONA THA KI GAALIYA PADE

[@Garib.Nurse1]

Direct copy paste kr do

[@puneetsingla2156]

Xlookup is best

[@GyaniAbhijeetji]

Yes sure and it is available in updated version of office 365 but they don't have update version this formula will help a well they can apply index+matc

[@ramizazam5380]

Yes is mn error k 99% chance hn

[@CMAAvinash]

Alt + a + q

[@akashsony7534]

it's not working

[@amitsaha3818]

Can you help me to use an formula ???

[@GyaniAbhijeetji]

Ask

[@sagarashokrao5486]

Hai, how does that names difference compared to Vlookup?

[@GyaniAbhijeetji]

This trick not dynamic but Vlookup formula is dynamic

[@sagarsoni996]

Nice work but if data change as per requirement, continue each and every time we took advance filter... But in vlookup data change reference data also change... automatically....if vlookup formula use perfectly..

[@GyaniAbhijeetji]

Yes it will be dynamic when you use vlookup it's totally depend on your situation

[@Thecomputereducation2530]

Pin mastersheet link

[@cnspicture]

sir isme jo camera ka option a raha hai wo kaise ayega ye bata do plz

[@GyaniAbhijeetji]

kon sa camera ka option mein smajha nahi

[@JashanOfficial]

itna detail wala excel course kaha se seekhein

[@GyaniAbhijeetji]

Download our App abhijeetji technical 4m and Purchase from there if any inquiry regarding course you can message inside the app through chat option

[@Amazeproductions158]

skill honi chaiye khi s h 10 ms 4

[@hemantchouhan4114]

Mujeh class lena hai online any information about

[@GyaniAbhijeetji]

Yes I provide call me 9647586598

[@Mlbb_Nothing_Gaming]

lol xlookup 😂 aacha udaa

[@defence_forces]

Can it fetch more than one data

[@GyaniAbhijeetji]

Yes

[@98Yourahul]

Esa kaam diya ki fat ke char ho gyi 😂😂😂

[@laksansingh4900]

we can't get exact value with this we can copy paste only this can not find true match with this

[@GyaniAbhijeetji]

I think you common value doesn't meet criteria that's why not finding

[@kumarabhishek6213]

File hang lot not useful

[@nitishverma6878]

Agar yhi formula ke through krna hoga toh kaise krenge

[@GyaniAbhijeetji]

Vlookup formula tumhe use karna padega hunara ek aur channel hi abhijeetji technical 4m waha vlookup formula basic to advance Maine bataya hai

[@nitishverma6878]

@@GyaniAbhijeetji tried but mujhe jo chalenge diya hai mere friend ne usme vlookup work nhi kr rha. Aapka method work toh kr gya hut its. Sheet is saying do this by formula.😅 Looking to hear from you.

[@TradeR8933]

Cntrl+g

[@nikhilrustagi5161]

How to get this data

[@GyaniAbhijeetji]

Download our App abhijeetji technical 4m and message me inside the app

[@royaloffcial0146]

Bhai ye work nahi kar raha hai

[@lakhi_kant]

Kon si version use kar rahe ho?

[@chandnijaiswal6018]

Ni ho raha h

[@GyaniAbhijeetji]

Watch carefully and Tru again

[@prachijain3463]

Result fully correct show nhi hua..

[@GyaniAbhijeetji]

What's the problem Agar aapke data mein multiple duplicate values hai to ye Tricks not work then you have to use index With match if you are facing problem message me on instagram I will fix your query instagram I'd abhijeetji technical 4m

[@premshankargupta6374]

BIWI HEE DARA SAKTI HAI BHAGVAN KO BHEE

[@nirajkhubber5456]

Maching formula h ye

[@GyaniAbhijeetji]

Yes it will match but ye dynamic nahi hai

[@kevalsoni4985]

pivot table bhi use kar sakta hai na ?

[@GyaniAbhijeetji]

Pivot Table is not lookup formula dear pivot table report ko summarize karne ke liye use karte hain

[@kevalsoni4985]

@@GyaniAbhijeetji 👍 thank you ji

[@SKumar12111]

Very good👍

[@rehanearningyt5383]

Sir isko copy kr ke nhi laa skte kia ? Please reply me

[@GyaniAbhijeetji]

LA sakte ho but one by one karoge to bahoot time lagega

[@debabratabasak4850]

@@GyaniAbhijeetji yeh copy paste type hai bhai ...vlookup type nhi hai

[@GyaniAbhijeetji]

@@debabratabasak4850 not copy paste I think you r beginner in excel

[@pr82212]

Alt a q

[@highlightsun6768]

जय सीताराम की ❤

[@simrankewat2111]

Work nahi kiya

[@GyaniAbhijeetji]

You are doing something wrong watch carefully and let me know

[@RanjeetSingh-kz5hi]

Legends use copy paste 🤣

[@GyaniAbhijeetji]

🤣🤣

[@SKAUTOTECHh]

Where are you learn ms excel

[@GyaniAbhijeetji]

Online if you r intrested to learn let me know

[@SKAUTOTECHh]

@@GyaniAbhijeetji sure I am interested

[@GyaniAbhijeetji]

@@SKAUTOTECHh join our course only just 999 download our App abhijeetji technical 4m and Purchase basic to advance Excel Mastery Course