Most valuable professional
  • Hot Topics

Excel Filter using not FILTER but formula

I have the following data on sheet1 COLOUR Grey White Crema Crema 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel