You are reading a single comment by @hurricane_run and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
hurricane_run
Anyone any good with Google sheets? I'm trying to pull the nth non blank cell from another sheet - formula works within same sheet but when I try and import range from the one I want to pull from I am getting the 'Argument must be a range' error.
What works within my sheet:
=ArrayFormula(INDEX($O$23:$O$300,SMALL(ROW($O$23:$O$300)+(100*($O$23:$O$300="")-22), 2))&")
What doesn't work when I try and applyh the above to data from another sheet:
=ArrayFormula(INDEX(IMPORTRANGE("Other sheet","Dashboard!Q4:Q50"),SMALL(ROW(IMPORTRANGE("Other sheet","Dashboard!Q4:Q50")+(100*(IMPORTRANGE("Other sheet","Dashboard!Q4:Q50")="")-3)),1))&"")
Any help greatly appreciated!