Him I am trying to use your formula to view information from Column A and Column C and ignore Column B. Here is the formula I use: =FILTER({'Visual Testing'!A4:A32;'Visual Testing'!C4:C32};'Visual Testing'!A4:A32 "") However, I receive an the "Filter has mismatched range sizes. Expected Row count: 58, column count: 1. Actual Row count: 29, column count 1" error. I've tried it the way shown in the video for filtering by just clicking on column, but then the error show instead of 58 2000 and instead of 29 1000 (which is the total amount of rows in that spreadsheet). Any pointers to what could be causing this would be great :)
Hi i have been using your formula but there is error message like this: In ARRAY_LITERAL, an Array Literal was missing values for one or more rows. What it means? How can i solve it
I am not understanding your use case? Why is it necessary to skip the a column? I would suggest that you organize your data more appropriately so that you do not need to skip any columns.
Excelente vídeo! Eu até consegui outra solução mas a sua é muito mais simples. Minha solução foi: =FILTER(FILTER('2022alunos'!A11:G1000;'2022alunos'!$C$11:$C$1000"");{1\0\1\1\1\0\1})
Hi I have been following your step by step guides and I am struggling on my Mac. Do you have a temple you can offer
IF you are using google sheets it should work no problem on a mac. The only time that it will differ is if you are using excel
Him I am trying to use your formula to view information from Column A and Column C and ignore Column B. Here is the formula I use:
=FILTER({'Visual Testing'!A4:A32;'Visual Testing'!C4:C32};'Visual Testing'!A4:A32 "")
However, I receive an the "Filter has mismatched range sizes. Expected Row count: 58, column count: 1. Actual Row count: 29, column count 1" error. I've tried it the way shown in the video for filtering by just clicking on column, but then the error show instead of 58 2000 and instead of 29 1000 (which is the total amount of rows in that spreadsheet). Any pointers to what could be causing this would be great :)
Hi i have been using your formula but there is error message like this: In ARRAY_LITERAL, an Array Literal was missing values for one or more rows. What it means? How can i solve it
So on Google Sheets I have this:
=iferror(FILTER('RAW DATA 2'!$B$2:$G,'RAW DATA 2'!$B$2:$B>=$B$1,'RAW DATA 2'!$B$2:$B
I am not understanding your use case?
Why is it necessary to skip the a column? I would suggest that you organize your data more appropriately so that you do not need to skip any columns.
Not working.
Error
FILTER has mismatched range sizes. Expected row count: 2997, column count: 1. Actual row count: 999, column count: 1.
your matches are not correct, or it is not finding a match.
It does work .
Excelente vídeo!
Eu até consegui outra solução mas a sua é muito mais simples.
Minha solução foi:
=FILTER(FILTER('2022alunos'!A11:G1000;'2022alunos'!$C$11:$C$1000"");{1\0\1\1\1\0\1})