Hi All,

Column A has a number of values descending vertically e.g. 1, 1, 2, 3, 4, 4, 5 etc. For example, let's say A2:A30

In column D I want a formula that I can drag down, that replicates the only the original data in this array e.g. 1, 2, 3, 4, 5.

My array changes month to month which is the reason I'm looking for a quick fire solution to this, as oppose copy, paste and remove duplicates.

Thanks