Lies | search
Click here to view Lies news from 60+ newspapers.
Bookmark or Share- Manage external data ranges and their propertiesYou can change the properties of an external data range to control data that has been imported into a worksheet through a connection to an external data source, such as a database, a Web query, or a text file.
- IF function - Microsoft SupportThe IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
- Count unique values among duplicates - Microsoft SupportCount the number of unique values by using a filter. You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.
- Guidelines and examples of array formulas - Microsoft SupportAn array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. Array formulas can return either multiple results, or a single result.
- HLOOKUP function - Microsoft SupportUse HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for "Horizontal."
More
