UNIQUE with FILTER based on partial text

[onthegreen03]

Hi All - I have a list of unique codes, starting with either Z1A, Z1B, or Z1C (see the list below), the list is in a tab named "Control Panel". In the event more codes get added I want to be able to look for unique codes based on the first 3 characters, so for example all of the ones starting with Z1A are grouped on another tab named "Summary", in column B. Can someone help me with the correct formula? I tried a combination of UNIQUE and FILTER (filtering on the first 3 characters) but was not able to get it to work properly. Please let me know if you need additional information. Thanks in advance!

 

[Fluff]

How about

=UNIQUE(FILTER('Control Panel'!B2:B10000,LEFT('Control Panel'!B2:B10000,3)="Z1A"))

 

[onthegreen03]

Fluff, as always you delivered the right and simple answer. THANKS!

 

[Fluff]

Glad to help & thanks for the feedback.