Hi, I am trying to write a formula that will list (in a separate column)the
values that occur only once in another ccolumn.
Eg Column A has the values:
100
100
120
120
120
130

And I would like columb B to list:
100
120
130
....but without any gaps in the rows.

Can anyone help?

Thankyou