# Lists and filter

**URL:** <https://community.hubspot.com/t/lists-and-filter/18881>\
**Category:** Tips, Tricks & Best Practices\
**Created:** [February 19, 2020, 1:13pm UTC](https://community.hubspot.com/t/lists-and-filter/18881 "2020-02-19T13:13:06Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Plank](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/plank/32/35608_2.png) [@Plank](https://community.hubspot.com/u/Plank)\
**Post date:** [February 19, 2020, 1:13pm UTC](https://community.hubspot.com/t/lists-and-filter/18881/1 "2020-02-19T13:13:06Z")

</div>

Hi,

I’m trying to create a list or a filter to show me comapnies by “PLZ” (Postcode).

Both ways don’t let me chose futher options, linke e.g.

PLZ starts with… 8\*

Options are blocked with a red sign.

Both, list selecting and filter work (or don’t work) the same way. No difference, when trying.

Can you help me to mke it work?

Thx

Julia

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [February 19, 2020, 1:26pm UTC](https://community.hubspot.com/t/lists-and-filter/18881/2 "2020-02-19T13:26:17Z")

</div>

Hi Julia,

I’ve found a solution [here](https://community.hubspot.com/t5/Lists-Lead-Scoring-Workflows/Creating-a-contact-list-using-zip-code-ranges/td-p/243514) but it sounds like you tried that exactly.

One work-around that I could see is downloading the csv of all zip codes in Germany [here](https://www.suche-postleitzahl.org/downloads) (box on the right) - and then copy and paste the whole list into the filters field. This usually takes a moment for a long list (potentially ~29k zip codes) but usually works. Just give your internet browser a moment to cope.

If none of these work, this might be a bug worth flagging with support.

Hope that helps!

Karsten

---

<div class="post-metadata">

**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\
**Post date:** [March 5, 2020, 2:48pm UTC](https://community.hubspot.com/t/lists-and-filter/18881/3 "2020-03-05T14:48:29Z")

</div>

Hi Julia

You can have multiple filters and can use \* to define all fields.

For example have I filtered here for postcodes containing 10 and 22 and get the corresponding results. Is that what you meant or where you after something else?

Frank

 ![Screenshot 2020-03-05 at 15.38.46.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/9/c9f2c54bb02b48387288be94bf12e9758a0e9ac5.jpeg)

---

<div class="post-metadata">

**Author:** ![jonathan18](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@jonathan18](https://community.hubspot.com/u/jonathan18)\
**Post date:** [December 14, 2024, 1:52pm UTC](https://community.hubspot.com/t/lists-and-filter/18881/4 "2024-12-14T13:52:26Z")

</div>

How can I create a list or filter to display companies by postcode (PLZ), such as those starting with “8\*”, when options are blocked with a red sign?

---

<div class="post-metadata">

**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\
**Post date:** [December 14, 2024, 2:12pm UTC](https://community.hubspot.com/t/lists-and-filter/18881/5 "2024-12-14T14:12:19Z")

</div>

Hi @jonathan18

Not sure what you mean by “options are blocked with a red sign”. Can you maybe include a screenshot that shows what you are doing, where in the tool and what you are seeing.

Cheers

Frank

---

<div class="post-metadata">

**Author:** ![jonathan18](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@jonathan18](https://community.hubspot.com/u/jonathan18)\
**Post date:** [December 14, 2024, 7:12pm UTC](https://community.hubspot.com/t/lists-and-filter/18881/6 "2024-12-14T19:12:56Z")

</div>

How can I create a list or filter to display companies by postcode (PLZ), such as those starting with “8”, when options are blocked with a red sign? Just [click here](https://koziolthomseye.com/glasses-and-contacts/)

to get more info.

---

<div class="post-metadata">

**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\
**Post date:** [December 14, 2024, 7:42pm UTC](https://community.hubspot.com/t/lists-and-filter/18881/7 "2024-12-14T19:42:59Z")

</div>

Hey @jonathan18

Did you accidentally put a random link in there or are you spamming this forum? 🤔🙄

Frank