@excelwithmarc: Often you’ll need a unique id to use a Vlookup or Sumif function. You’ll want to quickly see if there’s duplicate ids in your data set otherwise Vlookup and Sumif will return the same values for the duplicates which you don’t want. This video shows you exactly how you can highlight duplicates so they stand out in your data Then you can decide if you need to delete the rows or not If you found this useful, follow for more tips like this in Excel #excel #microsoftexcel #exceltips #exceltricks #msexcel #excelpro #learnexcel #spreadsheet #fyp

excelwithmarc | Excel with AI

Open In TikTok:

Region: GB

Thursday 24 April 2025 21:15:12 GMT