How do i add an auto-filter in an Microsoft Excel file?
To add an auto-filter in Microsoft Excel, follow these steps:

1. Open the Excel file that you want to add the auto-filter to.
2. Select the range of cells that you want to filter.
3. Click on the Data tab in the ribbon at the top of the screen.
4. Click on the Filter button in the Sort & Filter group.
5. Excel will add drop-down arrows to each column header in your selected range.
6. Click on the drop-down arrow for the column that you want to filter.
7. Select the criteria that you want to filter by from the list of options.
8. Excel will filter your data based on your selected criteria.

You can also use multiple criteria to filter your data by selecting Filter by Color, Text Filters, or Number Filters from the drop-down menu.
Thanks! That worked.

While working on some formulas though, I made a loop of cells referencing each other. Eventually it should stabilize, but it gives a circular reference error. Is there a way to allow it to continue calculating until it gets the answer?
Unfortunately, Excel doesn't allow circular references to continue calculating indefinitely, as it can lead to incorrect or infinite results. However, you can adjust the circular reference settings to control how Excel handles circular references in your worksheet.

To do this, follow these steps:

1. Click on the File tab in the ribbon at the top of the screen.
2. Click on Options in the left sidebar.
3. Click on Formulas in the left sidebar.
4. Under the Calculation options section, select the Enable iterative calculation checkbox.
5. Set the Maximum iterations value to a high number, such as 1000.
6. Set the Maximum change value to a low number, such as 0.001.
7. Click OK to save your changes.

With iterative calculation enabled, Excel will attempt to calculate the circular reference a set number of times, as specified by the Maximum iterations value, before stopping and returning the current result. The Maximum change value controls how much the results can change between iterations before Excel stops calculating.

Keep in mind that circular references can lead to inaccurate or unexpected results, so it's generally best to avoid them if possible. If you're having trouble resolving the circular reference in your formulas, you may need to restructure your worksheet or formula to avoid the circular reference.