Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Criteria is what you are looking for. i.e. a name or an item or a number. Therefore, if I wanted to know how many times a particular person’s name appeared in a list then my formula would look like ...