I have flight log speadsheet containing a couple of thousand records. One column contains the three letter aircraft registration. I want to dispay an alphabetical list of the individual registrations on another sheet. There are about 30 unique aircraft regos that repeat frequently through out the column.
Essentially I need a way to find and display every item from one column in another column but only once. Preferably in alphabetical order.
Can someone please tell me which formula I should use to achieve this.
Source Result
EBW EBQ
EBQ EBS
EBS EBW
EBS EBY
EBY ECC
EBW
EBW
ECC
EBY
EBW
ECC
EBY
Essentially I need a way to find and display every item from one column in another column but only once. Preferably in alphabetical order.
Can someone please tell me which formula I should use to achieve this.
Source Result
EBW EBQ
EBQ EBS
EBS EBW
EBS EBY
EBY ECC
EBW
EBW
ECC
EBY
EBW
ECC
EBY