Brad Howard | search
Click here to view Brad Howard news from 60+ newspapers.
Bookmark or Share- TEXTSPLIT function - Microsoft SupportSplits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function.
- Turn automatic completion of cell entries on or offMicrosoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic completion, you can turn this option off. Click File > Options.
- COUNTIFS function - Microsoft SupportCOUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: criteria_range1 Required. The first range in which to evaluate the associated criteria. criteria1 Required.
- LINEST function - Microsoft SupportThe LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.
- Count unique values among duplicates - Microsoft SupportHow to count the number of unique values in a range that contains duplicate values in Excel.
More
