If you learn how to filter in Excel to only show certain columns, this is how you can do it. <br /><br />Show Selected Columns <br />=FILTER(A5:H17,(COLUMN(A:H)=COLUMN(B:B))+(COLUMN(A:H)=COLUMN(D:D))) <br /><br />Show additional column <br />=FILTER(A5:H17,(COLUMN(A:H)=COLUMN(B:B))+(COLUMN(A:H)=COLUMN(D:D))+(COLUMN(A:H)=COLUMN(G:G))) <br /><br /><br />So, this formula filters the original range A5:H17 and includes rows where the data in the current column is either in column B or column D. Other rows are excluded from the filtered result. <br /><br /><br />🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗 <br />Filter Excel to only show certain columns - Excel Tips and Tricks <br />https://youtube.com/shorts/tIWr5im7l0g?si=PHfITzbjXFiWCufS <br /><br />Filter Excel to only show certain columns for large dataset - Excel Tips and Tricks <br />https://youtube.com/shorts/UsmMcoUl7aE?si=vILFg8MSaYaMFs3N <br /><br />Filter Excel to only show certain columns for large dataset - Excel Tips and Tricks - Detail Explanation <br />https://youtu.be/ZcGHuJq_zL8?si=wE0nesfQ_gkAZKpG <br /><br />Display only selected columns in Excel - Excel Tips and Tricks <br />https://youtube.com/shorts/D3mQEA3Slac?si=JPDOVOjxKwH8F95X <br /><br /><br /><br />excel filter show selected columns,Excel Filter Function - choose certain columns as output,How do you filter Excel to only show certain columns?,How do I show selected filter values in Excel?,How to filter only one column in Excel without affecting the others?,How do I exclude columns from a filter in Excel?, <br /><br />Check out my complete suite of Microsoft Excel Tips and Tricks. <br />https://www.youtube.com/@RabiGurungXybernetics/shorts <br />https://www.tiktok.com/@xybernetics247 <br />https://www.instagram.com/rabi.gurung247/ <br />https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/ <br />https://twitter.com/XyberneticsInc/media <br />https://www.reddit.com/r/Excel247/ <br />https://www.facebook.com/XyberneticsInc/reels/ <br /><br />#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks
