I have a pivot table and I like to use the filter to look up a group of addresses that will tell me how many jobs are open and closed under that specific address. The problem I have is let's say I have a list of customers and their address reads 15 Smith Street the other customers their address is 115 Smith Street. When I type in 15 Smith Street both 15 and 115 Smith Street are displayed. Is there a way to fix this so that when I type 15 Smith only those customers show or when I type 115 only these customer show. But as of right now when I type in 15 Smith Street both 115 and 15 is being displayed. I'm sorry I don't know how else to explain this, this was the best way to explain.
Thank you for the help and apologies for the description.
Bookmarks