0
I have a question in excel. I have a table with the columns "Seller", "Customer" and "City". would like to get a way to see all results achieved, for a particular Seller in a particular city, ie see all customers of that Seller in that city.
Need this result in cells, without by dynamic table, so that the user selects through a List the possible values for "Seller" and "City"
Can someone help me?
PS: One problem is that there may be the same customer in different cities with different sellers
Tried using conditional formatting? and make the lists where it will vary according to each seller?
– Luiz Augusto
I don’t know what you mean
– user147478
Would that be about right? https://www.youtube.com/watch?v=Y5tyAo77M_U
– Luiz Augusto
sublists solve the problem in parts. But since I need a larger chain effect (there are 3 chain criteria) they do not solve
– user147478