Hello all,

I want to use several "Filters" (/"Sort & Filter") in the same sheet. I have three different blocks, like this:


Product class I:

Product A // Design A-1 // Price A-1 // Design A-2 // Price A-2
Product B // Design B-1 // Price B-1 // Design B-2 // Price B-2
Product C // Design C-1 // Price C-1 // Design C-2 // Price C-2

Product class II:

Product P // Design P-1 // Price P-1 // Design P-2 // Price P-2
Product Q // Design Q-1 // Price Q-1 // Design Q-2 // Price Q-2
Product R // Design R-1 // Price R-1 // Design R-2 // Price R-2

Product class III:

Product X // Design X-1 // Price X-1 // Design X-2 // Price X-2
Product Y // Design Y-1 // Price Y-1 // Design Y-2 // Price Y-2
Product Z // Design Z-1 // Price Z-1 // Design Z-2 // Price Z-2


I simply want one filter per Product class (so that I can filter out the wanted product with designs&prices, from each class seperately). However, Excel only seems to allow me to have one single filter for the whole sheet.

Is there a solution?


Thanks in advance!