Ask Your Question

How do i make a list of unique numbers from a dataset? [closed]

asked 2019-02-14 18:36:08 +0100

Brian29 gravatar image

In a spreadsheet I have a set of integer numbers in cells A1 to A12. For example 6,6,6,7,6,6,6,5,6,4,6,6.

I want to produce a list in - let's say - cells A15, A16, A17 etc of the numbers in the dataset in ascending order. In the above example I would want to see 4,5,6,7 i.e. four unique numbers. Theoretically the number of unique numbers could be anything from 1 to 12.

I have looked at all the functions and haven't a clue. Can anyone point me in the right direction please?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-02-18 17:29:32.018940

1 Answer

Sort by » oldest newest most voted

answered 2019-02-14 18:50:50 +0100

erAck gravatar image

Mark/select the data range and choose menu Data -> More Filters -> Standard Filter...; there with Condition = choose Value Not Empty, under Options check No duplications and Copy results to and input/choose a cell to start the output at. Hit OK. Then with the result still being automatically selected click the Sort Ascending button.

edit flag offensive delete link more


Thanks very much for your very quick reply. This has certainly put me on the right track.

Brian29 gravatar imageBrian29 ( 2019-02-15 10:27:54 +0100 )edit

It would be nice if you then marked the answer as correct by clicking the checkmark and also upvote. Thanks.

erAck gravatar imageerAck ( 2019-02-15 11:32:18 +0100 )edit

I have marked as correct but it seems I get an error message ">5 points required to upvote" when I try to upvote

Brian29 gravatar imageBrian29 ( 2019-02-15 12:04:06 +0100 )edit

Hum.. yes might be. Thanks for trying and marking as correct.

erAck gravatar imageerAck ( 2019-02-18 17:29:22 +0100 )edit

Dear erAck, I, too, appreciate your clear reply. Hours of frustration resolved with a few keystokes ! Can't find an upvote check mark. Thanks very much !

robbglass gravatar imagerobbglass ( 2019-12-27 19:08:46 +0100 )edit

Question Tools

1 follower


Asked: 2019-02-14 18:36:08 +0100

Seen: 44 times

Last updated: Feb 14 '19