Filter Excel to only show certain columns for large dataset - Excel Tips and Tricks

If you learn how to filter in Excel to only show certain columns, this is how you can do it.

Show Selected Columns
=FILTER(A5:H17,(COLUMN(A:H)=COLUMN(B:B))+(COLUMN(A:H)=COLUMN(D:D)))

Show additional column
=FILTER(A5:H17,(COLUMN(A:H)=COLUMN(B:B))+(COLUMN(A:H)=COLUMN(D:D))+(COLUMN(A:H)=COLUMN(G:G)))


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.


🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Filter Excel to only show certain columns - Excel Tips and Tricks
https://youtube.com/shorts/tIWr5im7l0g?si=PHfITzbjXFiWCufS

Filter Excel to only show certain columns for large dataset - Excel Tips and Tricks
https://youtube.com/shorts/UsmMcoUl7aE?si=vILFg8MSaYaMFs3N

Filter Excel to only show certain columns for large dataset - Excel Tips and Tricks - Detail Explanation
https://youtu.be/ZcGHuJq_zL8?si=wE0nesfQ_gkAZKpG

Display only selected columns in Excel - Excel Tips and Tricks
https://youtube.com/shorts/D3mQEA3Slac?si=JPDOVOjxKwH8F95X



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?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@RabiGurungXybernetics/shorts
https://www.tiktok.com/@xybernetics247
https://www.instagram.com/rabi.gurung247/
https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/
https://twitter.com/XyberneticsInc/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks