In daily work, Excel is a powerful data-processing tool that offers many features to help users manage and analyze data efficiently. This article introduces several simple but powerful Excel functions and explains their usefulness and application scenarios.
1. SEQUENCE
Function: The SEQUENCE function generates a series of numbers based on the specified rows and columns.
Common format:
=SEQUENCE(rows, [columns], [start], [increment])Example: If you need to convert the names in column A into multiple rows and columns, enter the following formula in cell D6:
=INDEX(A:A, SEQUENCE(E3, E4, 2)) & ""2. SORT
Function: The SORT function sorts data in a specified range.
Common format:
=SORT(array, [sort_index], [sort_order], [by_col])Example: To sort evaluation records by the scores in column C, enter the following formula in cell E2:
=SORT(A2:C17, 3, -1)
3. SORTBY
Function: The SORTBY function sorts a range based on multiple criteria.
Common format:
=SORTBY(array, sort_index1, [sort_order1], [sort_index2], [sort_order2], ...)Example: To sort by department and evaluation score, enter the following formula in cell E2:
=SORTBY(A2:C17, A2:A17, 1, C2:C17, -1)4. UNIQUE
Function: The UNIQUE function extracts unique values from a dataset.
Common format:
=UNIQUE(array, [by_col], [exactly_once])Example：If you want to extract a list of unique personnel from the duty records, you can enter the following formula in cell E2:
=UNIQUE(B2:C8)5. FILTER
Function: The FILTER function filters records based on specified criteria.
Common format:
=FILTER(array, include, [if_empty])Example: To return all records related to the department specified in cell F2, enter the following formula in cell E6:
=FILTER(A1:C15, A1:A15=F2, "No records")Summary
The Excel functions introduced above can help users improve data-processing efficiency and simplify workflows. We hope these tips are helpful!
