资讯

How-To Geek on MSN3 天

How to Use the SORT and SORTBY Functions in Microsoft Excel

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
TechRepublic3 年

How to generate random text using the RANDARRAY() function in Excel

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.
TechRepublic16 年

Use an Excel array function to create an AverageIf function

Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally.