Excel Filter Not Filtering Correctly

Copper Contributor



I am trying to collect some data for a project off of my table in excel. When I go filter a certain cateogory, it doesn't work. Example, filtering vendors and I would like to see how much each vendor is producing. When I go to filter, it'll filter that vendor, but it will still show all the vendors on the page. It will also not bring up all that vendor has made and will scatter it across the table. Example below:



What can I do to fix this?

1 Reply


Could you please explain in more details what are doing. Right now: you have data with vendors


Applying filter to Vendors shows all filtered vendors: