Hi all.
When I was working with a spreadsheet with over 600 records I run into this problem.

Here is the problem.
I have three product categories Core, Extended and Full, and I have three kinds of storage location that can store Core, Extended and Full product as well.

If a Storage can hold Core products, it will hold Extended and Full products as well. On the other hand, if the storage location is of the Extended type, it is just going to hold Extended and Full products.
And last, If the storage is a Full type facility , it just holds Full type products.

I would like to rank all the products under the specif Storage unit location (check image)Question.jpg

Would I have to create a VBA program to handle this problem. Any suggestion? Thank you in advance