Rage | search
Click here to view Rage news from 60+ newspapers.
Bookmark or Share- Count numbers or dates based on a condition - Microsoft SupportTo count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function. To count numbers or dates that fall within a range (such as greater than 9000 and at the same time less than 22500), you can use the COUNTIFS function.
- Count unique values among duplicates - Microsoft SupportThere are several ways to count unique values among duplicates. 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. Select the range of cells, or make sure the active cell is in a table.
- Count how often a value occurs - Microsoft SupportThere are several ways to count how often a value occurs. Use the COUNTIF function to count how many times a particular value appears in a range of cells.
- MATCH function - Microsoft SupportHow to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
- Create a drop-down list - Microsoft SupportYou can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
More
