Filter by column, sort by row
exceljet.net
Filter by column, sort by row
To filter a set of data by a column heading, then sort the result by row, you can use a formula based on the FILTER and SORT functions. In the example shown, the formula in I5 is: =SORT(FILTER(B5:G15,(B4:G4="group") (B4:G4=J4)),2,-1) This formula returns the "Group" column plus data for the year in J4, sorted in descending order by the values ...
Jun 27, 2024
Excel Filter Tutorial
How to add a filter in Excel! #excel
0:14
How to add a filter in Excel! #excel
TikTokexcelbyrob
37.1K viewsMar 8, 2023
Excel Filter Tool with Formula Tutorial
1:00
Excel Filter Tool with Formula Tutorial
TikToklearnexceltoexcel
70.8K viewsOct 19, 2023
Excel Pro Trick: Filter Data Dynamically with Excel FILTER Function - How to Tutorial | Learn Excel to excel
0:45
Excel Pro Trick: Filter Data Dynamically with Excel FILTER Function - How to Tutorial | Learn Excel to excel
FacebookLearn Excel to excel
507.5K viewsApr 9, 2023
Top videos
Use the Filter feature in #Excel to sift your data for specific values by row. Learn how: https://msft.it/6181TY98N | Microsoft Excel
1:04
Use the Filter feature in #Excel to sift your data for specific values by row. Learn how: https://msft.it/6181TY98N | Microsoft Excel
FacebookMicrosoft Excel
45.7K viewsJun 17, 2020
Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752
9:14
Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752
YouTubeexcelisfun
51.3K viewsSep 7, 2021
EXCEL Filter Rows & Columns
9:57
EXCEL Filter Rows & Columns
YouTubeData Untelligence
13.9K viewsMay 22, 2023
Excel Advanced Filter
Excel Advanced Filter Trick
Excel Advanced Filter Trick
xelplus.com
Nov 14, 2019
Master Advanced Filter in Excel Like a Pro #focusinguide #ExcelTips #ExcelTricks #AdvancedFilter #ExcelTutorial #DataAnalysis #LearnExcel #ExcelExpert #Productivity | Focusinguide
0:13
Master Advanced Filter in Excel Like a Pro #focusinguide #ExcelTips #ExcelTricks #AdvancedFilter #ExcelTutorial #DataAnalysis #LearnExcel #ExcelExpert #Productivity | Focusinguide
FacebookFocusinguide
42.5K views4 months ago
Advanced Filter in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! 🎁 Get Excel Templates, PDF Cheat Sheets, Trackers, and Trainings at the link in our bio! 🎯 Follow us on Instagram, YouTube, TikTok, and more at the link in our bio! #excel #exceltips #exceltricks #spreadsheets #tutorial | CheatSheets
0:29
Advanced Filter in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! 🎁 Get Excel Templates, PDF Cheat Sheets, Trackers, and Trainings at the link in our bio! 🎯 Follow us on Instagram, YouTube, TikTok, and more at the link in our bio! #excel #exceltips #exceltricks #spreadsheets #tutorial | CheatSheets
FacebookCheatSheets
411.4K views3 months ago
Use the Filter feature in #Excel to sift your data for specific values by row. Learn how: https://msft.it/6181TY98N | Microsoft Excel
1:04
Use the Filter feature in #Excel to sift your data for specific values b…
45.7K viewsJun 17, 2020
FacebookMicrosoft Excel
Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752
9:14
Filter by rows and columns: Excel Formula for Any Version of Excel! …
51.3K viewsSep 7, 2021
YouTubeexcelisfun
EXCEL Filter Rows & Columns
9:57
EXCEL Filter Rows & Columns
13.9K viewsMay 22, 2023
YouTubeData Untelligence
How to Filter Records and Data in Excel
5:18
How to Filter Records and Data in Excel
2.6K viewsNov 28, 2014
Study.com
Filter both rows and columns and reorder columns in Excel
3:06
Filter both rows and columns and reorder columns in Excel
1.6K viewsMay 1, 2024
YouTubeITmistic
Excel Data Filters, Column Filters, Microsoft Excel
4:15
Excel Data Filters, Column Filters, Microsoft Excel
5.1K viewsJul 12, 2013
YouTubeJD Lomax
How to Copy and Paste Filtered Values in Excel
0:43
How to Copy and Paste Filtered Values in Excel
463K viewsDec 29, 2024
TikTokmrexcel_sl
0:59
Use this FILTER trick to choose columns
8.5K viewsMar 3, 2024
YouTubeHow to Excel
0:55
Filter data in a range or table in Excel
Oct 28, 2014
Microsoft
3:48
Excel Filtering Revolution: FILTER by Column - Episode 2356
10.8K viewsAug 25, 2020
YouTubeMrExcel.com
8:43
Using the Excel FILTER Function to Create Dynamic Filters
516.2K viewsApr 5, 2021
YouTubeTechnology for Teachers and Students
2:39
Excel filter column: Filtering a column using two criteria (OR ope…
3.7K viewsOct 15, 2013
YouTubesoluzione
Filter every nth row
Aug 25, 2022
exceljet.net
24:08
Master Excel Filtering Techniques: From Basics to Advanced
58.5K viewsJan 29, 2025
TikToktech_bro50
6:30
How to Freeze, Split and Filter Column & Rows in Excel - MH Sci …
457 viewsSep 14, 2024
YouTubeMH Sci Tech
2:46
How to Filter Multiple Columns in Excel?
21 viewsFeb 28, 2025
YouTubeHey Insights
2:44
How to Use the Filter Function in Excel in 2023
795 viewsJan 25, 2023
YouTubeHow To X
16:22
How to Filter in Excel
534.6K viewsMay 31, 2020
YouTubeKevin Stratvert
5:18
Filtering rows in Excel
10K viewsDec 1, 2022
YouTubeAuditExcel Advanced Excel and Financial Mode…
2:02
How To Use Excel FILTER Function With Multiple Criteria and Return …
4.1K viewsMar 24, 2024
YouTubeExcel Bootcamp
4:46
Excel: Filtering Data
640K viewsFeb 8, 2016
YouTubeLearnFree
3:16
How to Filter Data in Microsoft Excel Like a Pro
265.9K viewsOct 15, 2009
YouTubeMichelle “La gringa” M
4:36
Excel Advance Filter | Filter Multiple Columns and Criteria in Excel
14.8K viewsAug 11, 2021
YouTubeLearn for Future
20:40
How To Use Excel FILTER Function With Multiple Criteria & Return Onl…
753 views1 year ago
YouTubeOfficeMonk 9
3:19
How to Use Filter Function Multiple Columns on Multiple Conditions i…
16.2K viewsOct 11, 2022
YouTubeAgriMetSoft Team
23:42
The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE T…
39K viewsAug 13, 2024
YouTubeCellmates
6:09
Excel Tips - FILTER Function Basics and Multiple Criteria with Column …
4K viewsJul 3, 2023
YouTubeCareer Solutions For Today
9:03
Advanced Filters in Excel | How to Filter and Copy Data with Multiple …
25.2K viewsJan 31, 2025
YouTubeAnser's Excel Academy
2:51
How to Create Filter in Excel
1.4M viewsJul 31, 2019
YouTubeExcel Tutorials by EasyClick Academy
See more videos
Static thumbnail place holder