If you have a column of data that contains duplicates, then you can use the advanced filter option to identify and copy the unique values to a different location. You can then easily count those values using COUNTA function or the ROWS function.
Perform the following steps to achieve this goal:
1. First make sure that your [...]
In Excel menu click Tools.
In the Tools menu click Options.
Click the Custom Lists tab.
Click the Add button. The cursor will move the List entries edit box.
Enter the data for your list separated by commas. E.g. East, West, North, South.
Now if you enter “East” in any cell and drag the fill handle, other [...]
You can save yourself allot of typing if you know how to make use of autofill feature in Excel.
Suppose you want to enter names of days in cells A1 to A7 (Sun, Mon, …. Sat). Here is what you do:
Enter “Sun” on cell “A1”.
Drag the fill handle across the [...]
