List of numbers

[nicolaforni]

Hi,

I have a list of numbers in sheet A, column A.
Some numbers are repeated more than once.
I would like to create another list with all numbers but none of them repeated. So if I have 2,2,4,5,5 I would like to see a list which shows 2,4,5.
How do I do that?

Thanks,
Nicola

[daddylonglegs]

Hello Nicola,

The easiest way would be to filter the numbers, assumes you have a header in the column. Select the column and use Data > Filter > Advanced filter and use the "Unique records only" option. You can send the list to another location if you want, or copy and paste it.

Alternatively, assuming your data is in A1:A100 you can use a formula approach. Put this formula in C1

=MIN(A1:A100)

and then in C2

=MIN(IF(ISNUMBER(A$1:A$100),IF(ISNA(MATCH(A$1:A$100,C$1:C1,0)),A$1:A$100)))

confirmed with CTRL+SHIFT+ENTER and copied down column

When you run out of numbers you'll get zeroes

[JBeaucaire]

highlight the column, click on Data > Filter > Advanced Filter

Click > Copy to another location
Fill out the Copy To: target
Click Unique records only

Voila.

[shg]

Thread moved to a question forum.