(I understand that perhaps this thread belongs under “Programming” or under “Functions”?)

The Auto-Filter drop-down list provides, in ascending order, all occurrences in the selected column cells, but only once; in other words, it detects repeated entries and does not duplicate them in the list.

My subject spreadsheet consists of several columns, with one column containing job numbers. Several rows may have the same job numbers, and I sort the list so the numbers are grouped. From the sorted list, I manually create a separate list that includes the job numbers only once, without duplicates, just as the Auto-Filter drop down list.

Is there a better way (other than manually) to achieve the same results; i.e., create a list that contains every unique job number but no repeats? As an added feature, I would like to count the occurrences as well!

Example:
Source
123456
234567
123456
564535
234567
123456
123456

Results
123456 – 4
234567 – 2
564535 – 1

Thanks!

Alex