A challenge for a WordPress expert

Hi,

I’d like to have the option of finding specific posts by choosing more than one category – Faceted / Guided navigation.

The clearest example I can think of is an ecommerce site. You can select items by price, then by colour, then by size etc… thus refining your search.

Is it possible to use this technique with posts?

The only solution I can see is repeating categories countless times as sub-categories.

Any advice would be very much appreciated!