Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

How to Divide Two Numbers in One Cell for Microsoft Excel. If your Excel cell or row contains two or more values, you can split that data across multiple cells. For Excel to divide the values ...