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.

Most function-key shortcuts also work in Google Sheets, but you may need to enable compatible spreadsheet shortcuts from the Help menu to access some familiar Excel shortcuts.

Microsoft adds a new Copilot function to Excel, letting users generate, analyze, and summarize data directly in spreadsheet ...

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