0

Each day I have several tabs that update different football leagues data from websites using importhtml. I filter each individual tab onto one separate tab. When one tab is empty and contains no data, it fails to return the others tabs data. Is there a way of asking this to check if its empty first or ignore that it is empty and continue to return the others? This is currently what I use which works when all tabs contain data. It doesn't when one tab is empty.

={Filter('Spain Review'!BN2:BQ15,'Spain Review'!$BN2:BN15<>"");Filter('French Review'!BN2:BQ15,'French Review'!$BN2:BN15<>"");Filter('German Review'!BN2:BQ15,'German Review'!$BN2:BN15<>"");Filter('Italian Review'!BN2:BQ15,'Italian Review'!$BN2:BN15<>"");Filter('Prem Review'!BN2:BQ15,'Prem Review'!$BN2:BN15<>"")}

0

Instead of using multiple FILTER functions, use only one:

=Filter({
'Spain Review'!BN2:BQ15;
'French Review'!BN2:BQ15;
'German Review'!BN2:BQ15;
'Italian Review'!BN2:BQ15;
'Prem Review'!BN2:BQ15
},{
'Spain Review'!$BN2:BN15<>"";
'French Review'!$BN2:BN15<>"";
'German Review'!$BN2:BN15<>"";
'Italian Review'!$BN2:BN15<>"";
'Prem Review'!$BN2:BN15<>""
})
1
  • thats great ! I didnt realise that was an option like that – MR H Dec 24 '20 at 21:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.