For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classes
Analyzing Data with Power BI
Microsoft Excel - Power Query (M365, 2021-2010)
Microsoft Excel - Power Pivot (M365, 2021-2010)
There are times you need to highlight duplicate data in your worksheet. This macro does the trick.
Application.ScreenUpdating = False
Rng = Selection.Rows.Count
For i = Rng To 1 Step -1
myCheck = ActiveCell
For j = 1 To i
If ActiveCell = myCheck Then
Selection.Font.Bold = True
Selection.Font.ColorIndex = 3
Application.ScreenUpdating = True