How to Filter Data Dynamically with FILTER function from a different worksheet in Excel - Video -1

How to Filter Data Dynamically with FILTER function from a different worksheet in Excel - Video -1
Linke to Video - 2 of Filter function by Computer Geek
• Filter Multiple Values...
The Excel FILTER function "filters" a range of data based on a given criteria. The result is an array of matching values the source range. When this array is the final result (i.e. the results are not feed into another function) matching results will spill over on to the worksheet. Simply put, the FILTER function allows you to easily extract matching records from a larger set of source of original data based on criteria you entered.
The results from FILTER are dynamic. When values in the source data change, or the source data array is resized, the results from FILTER will update automatically.
www.microsoft.com
www.udemy.com
www.lynda.com

[@tamimahmad1231]

It's getting easier and easier with excel with these new dynamic array function. first those Xlookup and now this filter function

[@ashishnehra3758]

great from micrsoft to have made our life that much easier wtih thses functions.

[@fatimaahsan3739]

Informative vedio and keep sharing 👍

[@hanobhattia7888]

EXCEL अब इन कार्यों के साथ एक डेटाबेस है

[@chachargreen1992]

Woowww very nice and informative video

[@atulshukal4072]

Very good Sir

[@relaxingmusic43]

nice sharing

[@alissaghom6001]

microsoft is leasing the new functions to make it easier easier and easier. great vid geek

[@alibaqar9799]

Wonderfully devised video

[@ajitagarkar8632]

nicely construed video. informative

[@tahirraza2324]

So simple yet so powerful this function is

[@timetime2930]

Informative video

[@najwanbilgarami5350]

This is so easy so brilliat and so greatly illustrated. very nice geak

[@ayeshavlogs769]

Great info sharing

[@shariqanasim7349]

Nice update…keep sharing … thanks

[@nikhilsk86]

Thank you so much this was extremely helpful and a saviour!🙂

[@lakhwabindari5158]

This function in combination with xlookup can make your excel as database. supeb sir

[@hirahafeez4489]

Bht acha content aur video tu kamal ki ha

[@azeezkhan2051]

Very useful informative and easy to implement

[@sabarana2866]

Wow zabrdst Kia bt ha

[@agartagil8708]

a bit different than xlookup for a practical purpose. great

[@fariharaja6140]

So easy and so useful

[@nailaali7182]

nice, easy and effective

[@ankitasochi7254]

Great job with thses functions

[@raofchachar1489]

Woowww very nice and excellent information

[@zahidsherani136]

This is so easy, so great

[@naeemhamdani2209]

Great and at par with those xlookups.

[@arishrohan3725]

Very interesting this filter and xlookup functions as these remind us the capabilities like databases. nicely illustrated by geek. hats off

[@dawoodshah6918]

very easy and useful

[@kashmirakashh2682]

Stay in touch keep providing knowledge

[@arhaamkhan1661]

That is absolutely superb

[@sharqanasim8193]

This is really what I need to learn...explain in a easy manner...thanks nice info....keep sharing

[@rambaalvina9021]

Very well done

[@ahanaamoli7570]

यह बहुत अच्छा है

[@imranusmani3044]

Amazingly easy and extremely useful

[@chickenbiryani4194]

Thanks for sharing

[@kamalzaka1792]

That's as easy as you could get

[@iffatwani2044]

a great companian for xlookup. great geek

[@sabaahmad7990]

Good 👍 you are send good video

[@alynaatehreem8141]

Keep it up sir...!!!

[@syedadnan5976]

superb job

[@aliashafiq2077]

Great ingormation thanks for sharing

[@nitigoyal517]

Amazing video great information

[@mithunshetty4275]

very well done

[@rajawaqas9517]

Very nice rhanks for sharing

[@colourfullife2338]

Great information and good video

[@tahnitmastoor2256]

So informative channel

[@haramfatma4207]

Good work

[@karimagha3855]

This filter funtion in combination with xlookup is so powerful

[@adilimam1773]

How to use xlookup with these filter

[@ComputerGeek340]

You can use xlookup with filter function by first using xlookup function to extract a value, say product ID and then using that product ID as criteria for filter function to extract all records related to that ID.

[@mayatanoli8320]

That's great sir

[@kousarsiddiqui2031]

Great informative vedio

[@saimajilani503]

With Xlookup and Filter function now we can used the worksheet as database.

[@rahulkapoor9230]

Excellent

[@mussnan5634]

Nice video thanks for sharing

[@specialcooking4156]

Very well explained keep it up 👍

[@earnwithabid4107]

This video is very informative

[@iqrawasim8750]

This is even more cool than xlookup.

[@RelaxingMusic-nu7zz]

full of informative

[@turgatawzal9442]

Great channel and great content. keep it up geek this is so cool

[@totalhyper72]

Thank you so much sir

[@nadiyahasan5926]

Very informative video

[@zeeshansikandar6836]

great function .

[@GangaRam-kb6iy]

XLOOKUP and FILTER functions are awesom

[@faheemburni2601]

Great job

[@mobtech4961]

so so awesome this filter and xlookp are

[@deedan1220]

Thanks for such gud video

[@anokhaladla872]

This has made the life hell lot easy

[@1zainabjameel298]

Very informative vdo 👍🏼

[@khalifaabdulsalam7264]

This is so great

[@priyachawla6060]

superb

[@totalhyper72]

Very nice

[@ahaanahmad6163]

Great information

[@sawairahussain2185]

very informative video

[@nabihahassan4367]

Superb sir. That's very nice to have this kinna functionality right here in Excel

[@92abidali]

This video very informative

[@anayajaved432]

Very nice channel !!!! Well done!!!!

[@heaventv4370]

Great channel great video keep it up

[@shehzadjamal9046]

Great funtion for analysis

[@asimtalpor6784]

Wonderful

[@devkohli9153]

very great

[@machoman7860]

informative sr

[@jiyamehta900]

great job

[@sweetyfakhar3959]

Good job thanks for sharing

[@alynaatehreem8141]

Well done...very kool n easy....!!!

[@salonimehta8446]

Job well accomplished

[@irfanullah4922]

boht grate

[@AbdulRahim-pk1px]

excellent

[@gudubhai5219]

Nice information

[@MamtaKumari-fc5zs]

So great

[@sujitshah4712]

very nice

[@AjitKumar-rx4gx]

wonderful

[@sushmaswami9107]

This is as great and as easy as XLOOOKUP function

[@jiwandutt3640]

एक्सेल में XLOOKUP और फिल्टर समारोह के ऐडिटियो के साथ अब अध्यादेश उपयोगकर्ताओं के लिए भी विश्लेषण का एक बड़ा साधन बन गया है।

[@tulipjoshi1449]

great sr

[@fanilajaved8928]

Very nice channelll... Well done !!

[@rajabasharat17]

very well done sir

[@blackbean9517]

Very nice video....

[@yakkitamukhi6041]

Very well done sr

[@tafheemhussain785]

great job. new to this channel great content

[@rohitbajlani3461]

really useful sir