You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

When you release your mouse button, Excel automatically fills the other cells with a sequential series of numbers. Drag your mouse across the data and number cells to select them.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Excel Calculated Columns TL;DR Key Takeaways : Excel 365 offers a feature called calculated columns, which allows for dynamic calculations that automatically update with changes in data.