Forum Discussion
Need help trying to extract data from a large worksheet
I have a worksheet with 20+ columns. I want to extract only specific columns of information in the rows that have a specific date. (i.e.) I want the project name, amount and comments for only the da...
This was very helpful. I have one more piece of criteria. If column F was a value, how could I limit the results to column F <> zero.
=INDEX(FILTER(Data!A2:Z1000,(Data!D2:D1000=A2)*(Data!F2:F1000<>0),,{1,6,16})