Extract distinct list from a range

[Ufoo]

Hello gurus,

I have learnt a great on how to extract a distinct list at www.get-digital-help.com. However, the formula in the following link is a handful to me. Would someone open it up for me please? Thanks: http://www.get-digital-help.com/200...nct-list-sorted-from-a-z-from-range-in-excel/

 

[PCosta87]

Hi,

I usually go with this one (see attached).
See if it works for you and let me know if you have any questions.