Using IMPORTRANGE within a FILTER

Question

I found this question asked in other places, but I can't seem to get my formula correct...

=FILTER(ShortInventory!N:N , ROW(ShortInventory!N:N) =MAX( FILTER( 
ROW(ShortInventory!N:N) , NOT(ISBLANK(ShortInventory!N:N)))))

This works, pulling data from a secondary tab on the existing spreadsheet. I would like to pull this directly from the external spreadsheet.

=FILTER(IMPORTRANGE("SOURCE","Responses!N:N") , 
ROW(IMPORTRANGE("SOURCE","Responses!N:N")) =MAX( FILTER( 
ROW(IMPORTRANGE("SOURCE","Responses!N:N") , 
NOT(ISBLANK(IMPORTRANGE("SOURCE","Responses!N:N")))))))

I've tried variations of this and get the #N/A

FILTER has mismatched range sizes. Expected row count: 122. column count: 1. Actual row count: 1, column count: 1.

I have no idea how to make this work.

I read about using QUERY with IMPORTRANGE in a FILTER, and modified my formula. It didn't work, but using this independently does reference the correct column. Searching for answers... =QUERY(IMPORTRANGE("Source","Responses!N:N"),"Select * where Col1 = '0'") — Jarod Thornton
– Jarod Thornton, Commented Mar 16, 2019 at 15:11
(Master with a tab pulling data from responses) docs.google.com/spreadsheets/d/… (Responses) docs.google.com/spreadsheets/d/… (Form) docs.google.com/forms/d/e/… — Jarod Thornton
– Jarod Thornton, Commented Mar 22, 2019 at 15:45

player0 · Accepted Answer · 2019-03-22 21:50:08Z

1

=FILTER(IMPORTRANGE("1gyAaxDzklUuhwBdLpMkb2jgrPmbJ9WxtdJ1JOO2d424","Responses!N1:N101"),
 ROW(A1:A101)=MAX(FILTER( ROW(A1:A101),NOT(
 ISBLANK(IMPORTRANGE("1gyAaxDzklUuhwBdLpMkb2jgrPmbJ9WxtdJ1JOO2d424","Responses!N1:N101"))))))

answered Mar 22, 2019 at 21:50

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using IMPORTRANGE within a FILTER

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related