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

Use data filter advanced filter and select only unique records
Take a look at the following:
http://www.contextures.com/xladvfilter01.html#FilterUR



"AO" wrote in message
...
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

Start by looking at Chip Pearson's...
http://www.cpearson.com/excel/duplic...tractingUnique
Then take a look at his...
http://www.cpearson.com/excel/noblanks.htm

Your other options are Excel's Advance Filtering capabilities or a macro.

HTH,
Gary Brown

"AO" wrote:

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