Data entry, it’s where users love to copy and paste. Especially when their text is nicely arranged with multiple spaces, cartridge returns and line feeds amongst other special character formatting. In a perfect world this would be captured during input…
Find max or min values from a list of duplicates in Excel
In Excel sometimes you will need to find either the first or last value from a mixed list of values that also include duplicates. Later versions of Excel feature a Remove Duplicates button under the Data tab in the ribbon. …