Hi

I have the following number in a cells, I am looking to copy them over via a formula to create individual numbers with no duplicates.

Lets say in first column is the following numbers

1
1
2
2
2
3
3
4
4
4
4

I am looking to write a formula so in the next sheet all I have is the following

1
2
3
4

I had the following formula Cell A1 of next sheet = =Sheet2!A1
In Cell A2 I had this formula =IF(Sheet2!A2=A1,Sheet2!A2, Sheet2!A3)

This worked until I had the number occuring more than twice in the column

Thanks in advance

Jezza