Excel: Filter using not FILTER but formula


I have the following data on sheet1

COLOUR ART NO. BRAND SIZE SURFACE PACKING M2 CTN OUR CODE INC STK BOOK FREE
Grey GCM04 CEMENTUM 60 X 60 Matt 3 1.08 239.000.02 2,450.00 0
White GCM01 CEMENTUM 60 X 60 Matt 3 1.08 239.000.01 2,450.00 0
Crema GGS12 GRANTITE STONE 30 X 60 Rock 8 1.44 239.000.03 3,505.00 0
Crema GGS12 GRANTITE STONE 30 X 60 Rock 3 1.08 239.000.78 2,590.00 0
Can a drop box on sheet 2 specifying tile size pull data or without drop box , I know the normal filter is the best option but trying to spoon feed the sales team since some are weak users, they would hardly know how to use the FILTER option


This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of December 26, 2013.


For more resources for Microsoft Excel