Excel Pro Trick Filter Data Dynamically with Excel FILTER Function 𝙏𝙝𝙖𝙣𝙠𝙨 𝙛𝙤𝙧 𝙬𝙖𝙩𝙘𝙝𝙞𝙣𝙜 𝙩𝙝𝙚 𝙫𝙞𝙙𝙚𝙤! 𝙄𝙛 𝙮𝙤𝙪 𝙡𝙞𝙠𝙚 𝙩𝙝𝙚 𝙫𝙞𝙙𝙚𝙤 𝙥𝙡𝙚𝙖𝙨𝙚 𝙙𝙤𝙣'𝙩 𝙛𝙤𝙧𝙜𝙚𝙩 𝙩𝙤 𝙡𝙞𝙠𝙚 𝙞𝙩. 𝙖𝙣𝙙 𝙁𝙤𝙡𝙡𝙤𝙬 𝙩𝙝𝙚 𝙖𝙘𝙘𝙤𝙪𝙣𝙩 𝙩𝙤 𝙞𝙣𝙘𝙧𝙚𝙖𝙨𝙚 𝙮𝙤𝙪𝙧 𝙚𝙭𝙘𝙚𝙡 𝙠𝙣𝙤𝙬𝙡𝙚𝙙𝙜𝙚. ❎ 𝘿𝙤𝙣'𝙩 𝙛𝙤𝙧𝙜𝙚𝙩 𝙩𝙤 𝙛𝙤𝙡𝙡𝙤𝙬 𝙢𝙚 𝙛𝙤𝙧 𝙢𝙤𝙧𝙚 @𝙚𝙭𝙘𝙚𝙡_𝙛𝙤𝙧𝙢𝙪𝙡𝙖_𝙛𝙪𝙣 🔗 𝙎𝙪𝙥𝙥𝙤𝙧𝙩 𝙢𝙚 𝙤𝙣 𝙔𝙤𝙪𝙏𝙪𝙗𝙚 (𝙡𝙞𝙣𝙠 𝙞𝙣 𝙗𝙞𝙤) 🗃️ 𝙎𝙖𝙫𝙚 �

In this video, I wanted to show you how you can use the powerful FILTER function in Excel so you can return multiple values at the same time based on a certain criteria! This function can make your workflows really dynamic, and once you get more advanced, you can start combining it with other functions for some super cool functionality! #excel #data #analyst #exceltips 💻 | Excelwithkyle23

New video: Learn how to create macro buttons for Excel filters. Filters are probably one of the tools we use the most in Excel. It can be a time consuming task to apply filters using the filter drop-down menus. Especially when applying filters to multiple columns, or if you apply the same filters to the same reports every day or week. In this week's post and video I explain how to use the macro recorder to create a macro that filters multiple columns, and then create a button for it on the sheet