Google Docs ()FILTER to Excel

**royk2341** · 07-27-2015, 07:33 AM

I have a workbook that I have downloaded from Google Docs that contains a FILTER() formula. I have noticed that Excel doesn't recognize this. The purpose of this is to display the name from BJ only if BK is higher than 0 (indicating that I have this). Obviously the first part of the formula works fine. What can I do in Excel to make this work?

Here is the formula:

IF(COUNTIF('Tech info'!BK2:BK30,">0")=0, "No Artifacts", FILTER('Tech info'!BJ2:BJ30,'Tech info'!BK2:BK30>0))

And the array that it refers to is attached as I couldn't get it to be readable here.

Artifacts.pdf

**Tony Valko** · 07-27-2015, 08:46 AM

I didn't download your file.

IF(COUNTIF('Tech info'!BK2:BK30,">0")=0, "No Artifacts", FILTER('Tech info'!BJ2:BJ30,'Tech info'!BK2:BK30>0))

The Excel version would be...

This array formula**:

=IF(COUNTIF('Tech info'!BK$2:BK$30,">0")=0,"No Artifacts",INDEX('Tech info'!BJ:BJ,SMALL(IF('Tech info'!BK$2:BK$30>0,ROW('Tech info'!BK$2:BK$30)),ROWS(A$1:A1))))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

Google Docs ()FILTER to Excel

LinkBack

Thread Tools

Rate This Thread

Display

Google Docs ()FILTER to Excel

Re: Google Docs ()FILTER to Excel

Thread Information

Users Browsing this Thread

Similar Threads

Is it possible to use the filter function in Google Docs through Android mobile phone?

pull certain data from google docs form-produced spreadsheet to other docs

Converting spreadsheets from Microsoft Excel to Google Docs

Query function from google docs in excel 2011, anyone with a solution?

Uploading Excel Spreadsheet to Google Docs

Filter command from Google Docs not working on Excel

Google Docs/Excel - Percentage converts to Decimal

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions