A blank column contains cells with unsorted numbers.

[gestalt]

I want to extract values and craete new list.
For example, how do I retrieve the following:
Cell = Value
A1 8810
A2 8810
A3 8832
A4 8809
A5 8810
Into a list that looks like:
A1 8809
A2 8810
A3 8832

 

[Frank Kabel]

Hi
use 'Data - Filter - Advanced Filter' and check 'Unique entries'.
Afterwards sort the list

 

[duane]

you could first sort them in ascending order, and then filter, advance
filter, unique records (this requires a header row)