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?
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.
Thanks very much for your very quick reply. This has certainly put me on the right track.
It would be nice if you then marked the answer as correct by clicking the checkmark and also upvote. Thanks.
I have marked as correct but it seems I get an error message “>5 points required to upvote” when I try to upvote
Hum… yes might be. Thanks for trying and marking as correct.
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 !