5 array functions you need to know:
1. TRANSPOSE
Need to flip the rows and columns in your data table? Instead of manually interchanging each row and column, try the TRANSPOSE function. Just select the data you want to transpose as the array argument, and Excel will automatically flip your data.
Need to flip the rows and columns in your data table? Instead of manually interchanging each row and column, try the TRANSPOSE function. Just select the data you want to transpose as the array argument, and Excel will automatically flip your data.
2. SEQUENCE
Never waste time typing out numbered lists again using Excel’s SEQUENCE function. SEQUENCE quickly and easily creates a list of sequential numbers for you. Just enter the number of rows you want in the sequential list as the rows argument.
Never waste time typing out numbered lists again using Excel’s SEQUENCE function. SEQUENCE quickly and easily creates a list of sequential numbers for you. Just enter the number of rows you want in the sequential list as the rows argument.
3. UNIQUE
The remove duplicates data tool is out, and the UNIQUE function is in. The UNIQUE function returns a unique list of values in an array by removing the duplicates. UNIQUE can return unique rows or columns from the array using the by_col argument.
The remove duplicates data tool is out, and the UNIQUE function is in. The UNIQUE function returns a unique list of values in an array by removing the duplicates. UNIQUE can return unique rows or columns from the array using the by_col argument.
4. FILTER
Need to quickly apply filters to your data? Try using the FILTER function. FILTER filters an array by applying a criteria to the data and returning all of the entries that meet the criteria.
Need to quickly apply filters to your data? Try using the FILTER function. FILTER filters an array by applying a criteria to the data and returning all of the entries that meet the criteria.
5. SORT
Sorting data is a simple yet effective way to analyze data. The SORT function sorts data based on a column within the dataset. The sort_index is the column the data is sorted by, and sort_order determines whether to sort the column in ascending or descending order.
Sorting data is a simple yet effective way to analyze data. The SORT function sorts data based on a column within the dataset. The sort_index is the column the data is sorted by, and sort_order determines whether to sort the column in ascending or descending order.
Array functions are my favorite!
To learn all of Excel’s shortcuts and productivity hacks like these, make sure to sign up for my new course! #excel
Sign up now 👇
education.morningbrew.com/excel
To learn all of Excel’s shortcuts and productivity hacks like these, make sure to sign up for my new course! #excel
Sign up now 👇
education.morningbrew.com/excel
Follow me @exceldictionary for even more Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch, templates, and ebooks.
shop.morningbrew.com/collections/ex…
And if you never want to forget my excel tips at your desk, check out my shortcut merch, templates, and ebooks.
shop.morningbrew.com/collections/ex…
• • •
Missing some Tweet in this thread? You can try to
force a refresh
