Sometimes duplicate data is irritated you, sometimes it just makes it difficult to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them. Follow given below steps Select the cells you want to check for duplicates.Click Home > Conditional Formatting > Highlight Cells…
Category Archives EXCEL
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return…