Sub kTest() Dim k, e, v, i As Long k = Range("a1").CurrentRegion.Value2 With CreateObject("scripting.dictionary") .comparemode = 1 For Each e In k v = Split(e, ",") For i = 0 To UBound(v) If Len(v(i)) Then .Item(Trim(v(i))) = Empty Next Next If .Count Then Worksheets.Add Range("a1").Value = Join(.keys, ",") End If End WithEnd Sub

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…

The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…