QUERY formula combining multiple cells into one, despite them NOT meeting criteria

Tcerusseri 0
Viewed 20

This is the Formula:

=IFERROR(QUERY(Week7_Stats!$B4:$AH,"Select C Where D ='Top' and M > .5 Order by G Desc Limit 6"),"NA")

Now, this WORKS for Weeks 1 through 7, changing (of course) the week # in the formula.

The moment we go to Week 8 the formula suddenly starts merging the top 4 cells in the query range into the first cell despite the fact that they do NOT meet the "Where D = 'Top':

=IFERROR(QUERY(Week8_Stats!$B4:$AH,"Select C Where D ='Top' and M > .5 Order by G Desc Limit 6"),"NA")

I have tried changing the Column letters to Col2 and so on, no success. If I change the $B4 to $B7 it begins to work again.. however that forces a skip on stats that need to be grabbed.

Suggestions?

google-sheets
1 Answers

Try set the Query header to 0

=IFERROR(QUERY(Week7_Stats!A:AH,"Select C Where D ='Top' and M > .5 Order by G Desc Limit 6", 0),"NA")
Osm0
Related