where "range" is the range of cells that you want to check for duplicates and A2 is the first cell of your data. You can then filter the column with the formula to show only the duplicate values. (3/3) thanks ChatGPT for the assist