S shibulal Member Mar 14, 2012 #1 Hi, I have some results in column J which is being extracted by using Criteria. Some rows are empty, some are having the desired results.... Now my question is that is it possible to auto filter on the result (value greater than 0 or so) ?.
Hi, I have some results in column J which is being extracted by using Criteria. Some rows are empty, some are having the desired results.... Now my question is that is it possible to auto filter on the result (value greater than 0 or so) ?.
Luke M Excel Ninja Staff member Mar 14, 2012 #2 Apply your autofilter, then use a criteria of "greater than 0". AutoFilter does not care if the data is generated manually or via formula.
Apply your autofilter, then use a criteria of "greater than 0". AutoFilter does not care if the data is generated manually or via formula.
