Don't copy and paste in Excel‼️ Instead Use Amazing Function

In this video, you will learn how to use filter function in Excel.
#excel #exceltips #exceltricks #exceltutorial #computertips #advancedexcel #advancedexcel #excelshortcuts #excelshortcuts #excelformulas #filter

[@Kkkacarnaama]

Instead use pivot table sir

[@king-bw7zm]

😂😂😂 👌👌

[@broxxad]

Very helpful tip. Awesome.

[@aryakumar3570]

Use pivot table

[@krishnankuppaswamy7553]

Agree.
There are scenarios to make use of functions in certain cases. Then the FILTER function would come in handy.

[@thirumalrao6312]

Thank you bro. You always shows some useful formulas.

[@krishnankuppaswamy7553]

Wow ❤

[@Silver-Clouds]

Wonderful ❤

[@Shortandclearexcel]

Thank you 🤗

[@RonyAhmed143]

It can be done more easily by pivot table. No need to remember formula for that.

[@rahulkokate6292]

Usefull

[@Shortandclearexcel]

Glad you think so!

[@anhhoangminh9474]

Good.

[@user-zr2eg5jx3m]

I just watch similar video, the creator used xlookup function instead. At least I know I’ve got options.

[@brintochakraborty4010]

But this function is only available for MS Excel 2021,,,

[@kareemkhanh5372]

Helpful tips sir. Thank you sir

[@punchole]

Like this bro, really helpful

[@Shortandclearexcel]

Thank You

[@kuttanr7423]

When you select the above department cell D1 also F4 (just to free the row number not the column it should go on like D,E, and so on) otherwise when you copy the formula to D3 won’t it do the reference to D2???

[@mohammedazeemoddin6443]

Nice

[@Shortandclearexcel]

Thanks

[@90mlgaming85]

Super ana 😊😊😊

[@Shortandclearexcel]

Thank you

[@itwithsrs]

Superb helpful ❤❤

[@ifbut_then]

Thanks man

[@Shortandclearexcel]

Thank you🤗

[@priyankab3700]

Thanks sir👍😁

[@moduibrahim4251]

Thanks 🙏

[@arun4846]

Superb thanks bro ❤❤❤

[@lalithkumar76]

Insted of this simple use pivot.. Formula time and paste time will be saved. 😊

[@vgannal9448]

This is what I also try to say

[@joylynchinyama1634]

What's the difference between using V-lookup and filter

[@mythicgaming2316]

Please Share this Excel file for practice 😊

[@Shortandclearexcel]

Okay, will share

[@noshulal]

I have 4000+ rows data in one column and I want to convert every 10 rows into rows, transpose will not be useful as it is done manually and converting that lengthy (4k+) column will be a neck breaking task, Can any provide a Solution? Admin? Channel?

[@dipanshutiwari1678]

Like❌️love✅️

[@muhakbar4958]

Transpose bro, very simple

[@vidyadharkumar5701]

❤❤

[@kasamsanthosh1637]

Use V lookup

[@aslanpeteredmundpereja9221]

Sir i dont have the filter function how to add?

[@meetkcs]

Super... Very much helpful.

[@anuranjanrai5658]

FITERCML COPTION CAME IN MY EXCEL BUT NOT EXCEL NOT, WHAT SHOULD I DO?

[@Shortandclearexcel]

Will you elaborated?

[@mohsinrza5378]

Sir direct filter lga sakte hai formulay ki jarurat hi nhi padege

[@satyaEk]

Same like vlookup

[@ashleshavinchankar5270]

I have filterxml how to use it

[@BikeLaughLove]

Bhai use paste spl

[@radhikasurendranath8580]

Filter function is not working in my computer sir

[@abdulahad0]

Is this transpose?

[@emadhusain2611]

Bro why are we using filter function?

[@Mr.Mahesh_Bulletin]

artham kaledyu anna

[@sharookhali8404]

I am not able to find filter function

[@pankajm9216]

He is using Excel 365 version

[@RaynaOfTheAbyss]

lookup the QUERY function this can do the same thing but has different syntax.

[@amitk1208]

Use pivot table if u don't have excel 365

[@sarathr4495]

First method was easy 😏

[@imaman7338]

You should translate Hindi...

[@mohdhaiderkhan8556]

Pivot it😂

[@vicybaunser2861]

koi tareeka hai kya excel ke naya latest version mil jaye product key maang ta hai sala

[@aadityaaa093]

Pivot krde bhai

[@akshay5930]

What's with the face

[@dsomodasa2427]

Very helpful tip. Awesome.

[@leophrix]

Nice

[@Shortandclearexcel]

Thanks