With cell B2 selected, I can now use the fill handle in the bottom-right corner of the cell to duplicate this relative formula to the remaining rows of details.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

You don’t have to struggle or scratch your head when it comes to using Microsoft Excel. This guide for beginners will get you off to a solid start with Excel.