Return True Blanks - IF, VLOOKUP, IFERROR - Google Sheets

[@ExcelGoogleSheets]

IF & IFS functions kzbin.info/www/bejne/nniYp36Dl5V_ptE IF with Multiple Conditions kzbin.info/www/bejne/hH6YXpV3irVlb7c IF functions you should never use kzbin.info/www/bejne/bJTai6KBmb-bb5Y

[@JSpeedy306]

WHAT??? I struggled with this problem so many times and had to work my way around it. And the solution is TO WRITE NOTHING!? It's genius within its simplicity and I love it!

[@edsonaoki8025]

Due this kind of problem I choose define something like "ops", so I always can check it,rs, yes I´ve never tried to forget to write it! kkk

[@mmint-td9nx]

It took me hours to find the answer for this problem and I finally found this video. It worked. Thank you so much.

[@Udhxhehej]

Another great video, learned something on this channel every time. Something to consider: in certain scenarios this setup may suppress valid errors and using ISERROR (or some other way to uncover issues) along with this configuration may be helpful. Thanks again!

[@garychadwick1240]

Thank you. That has been bugging me for years and the solution was so simple. I always learn from you!

[@douglasteixeiradeabreu]

Estava ansioso por seus vídeos esse ano. Uma boa dica para o verdadeiro vazio, muito obrigado por ensinar isto.

[@edsonaoki8025]

adoro a elegância e simplicidade com que resolve situações bem complicadas. Por exemplo quando uma uma linha auxiliar ou 2 e transporta apenas a essência sem efeitos colaterais .Suas soluções sempre prezam pela máxima independência e nunca despreza o benefício do arrastar as formulas em colunas ou linhas. Nunca me canso de aprender como ser melhor seja em google sheets ou excel. Aguardo o dia em que abordar como usar as library do googlescript para Se posso exemplificar desenvolvi a função de dígito verificador na planilha A. Mas à frente tenho uma outra planilha B , e não posso usar a função sem enxertar o código na planilha B, em outras palavras queria usar a funcionalidade como um serviço. De qq forma tem minha sincera gratidão por me trazer de volta para as linhas de código.rs

[@miguelate]

I have a sheet that imports data from 2 different sheets through import range formula. The data appears in A1:A10 from one sheet and B1:B:10 from the other. We want to be able to type in any field without affecting the formula on the first row, which is import range. Is there a way of doing that. We want to be able to write over cells that are left blank, but with a formula on top we can't. Is that even possible?

[@reil3716]

I have a problem with my IF function, its not returning the value if the result is false. I'm doing a google form with morning and afternoon time log for employees but I'm having a problem processing the data if the employee only log at afternoon.

[@adityaprasadkar5606]

I have one lookup sheet from which I get data for my master sheet. But some of the lookup value was not updated so I am getting the #NA error in my master sheet. So how can I add my new values from the master sheet to my lookup sheet automatically? Could you please help me with this? Thanks in advance

[@Sulaimangalib]

Is there any way to get a notification when someone views my google sheet?

[@alex-coelho]

wait, Ctrl Shift enter is a keyboard shortcut for the array function?

[@ExcelGoogleSheets]

Yes, it is :)

[@nisargagza]

Excellent...Learn something new

[@dolphinsgroupofschools2995]

hi my name is sunil your videos are awesome. I watch your every video in dip. please make more videos for =regex

[@teoxengineer]

is tehere any way to find or replace " " with blank in excel. I tried to convert into blank cell instead of " " in excel, but it doesn't run. It shows "Not Blank"

[@ExcelGoogleSheets]

I think you gonna have to use a macro. Something like this should work over the area selected. for each cell in selection if cell.value = "" then cell.clearcontents end if next cell

[@vishaleee404]

u r great👍👍👍👍👏👏👏

[@apparelsword]

Hello, sir, why if I want to vlookup importrange the value of a cell that contains a formula, the value of that cell doesn't appear?

[@ExcelGoogleSheets]

Does it appear if you do importrange without a vlookup?

[@apparelsword]

@@ExcelGoogleSheets I have a problem: I have 3 spreadsheet files: 1. Master data file 2. the file contains the importrange Vlookup data from the first file, it works fine 3. file contains importrange Vlookup data from second file = value not shown What is the solution? Please help. Thank You

[@leeedwards8071]

This is brilliant, will replacing “” with blanks improve calculation speed? I own many sheets with lots and lots of formulas that can take a few seconds to calculate so could this improve the overall sheet? Especially when used in an array?

[@ExcelGoogleSheets]

I don't think this will improve the speed.

[@edsonaoki8025]

@@ExcelGoogleSheets yes, but a string with no chars still waste more than zero bytes.rs

[@Puner54]

Teacher... Nice Instruction! But how would you handle Blank Cell/s in the middle of an Athritmetic Array and keep the Math Correct?

[@ExcelGoogleSheets]

I guess that depends on the "Athritmetic". Mostly it's some kind of IF statement.

[@Puner54]

@@ExcelGoogleSheets Teacher...how would you make Cell E4 a "Non Blank Cell" while making Cells E7, E8, E9 and E10 "True Blank Cells"?

[@auberg7103]

@@Puner54 it's not clear the situation you describe, but as Teacher suggests you can try to create an IF statement and create your own ERROR i.e IF(ISBLANK(E4),IFERROR(1/0),SOMETHING)

[@Puner54]

@AuBerg Thanks for the Reply! Do you Work with Google Sheet much?

[@Grrymjo]

May I ask you why you deleted / made private 2 or 3 other videos from today? Are they only by subscription or something?

[@ExcelGoogleSheets]

They will be published at a later date.

[@bruno_veloso]

Awesome content, I missed your videos, somehow youtube stopped notifying me. Btw, where's the video "Learn Google Spreadsheets enviou o vídeo Google Sheets Pivot Table with KPI & Bar Graphs"? I'm really interested in that one.

[@ExcelGoogleSheets]

Yea, it's been 6+ months since youtube has been trying to tank the channel. Less than 1% of subscribers get notifications. The odd thing is if I don't post any videos the channel gets more views, if I post new videos it starts tanking the channel. So at this point I have pretty much 0 motivation to post new content. It's stupid. KPI video will be posted at a later date.

[@brunoveloso2524]

​@@ExcelGoogleSheets Oh man, keep doing your great work. On behalf of the people that watch your videos, I can say you do one of the most enlighted actions in the world: teaching. You can't imagine how positive you impact on people lives, you might be responsible for a lot of people being able to get promoted or hired on a job position. Keep going, for us!

[@nisargagza]

Excellent...I learn something new

[@davidfernandezbajo]

Wouldn't those be called null?

[@ExcelGoogleSheets]

I guess they would be undefined when you pass it to the function and then the function probably returns null. Impossible to tell without seeing the implementation of the function.

[@davidfernandezbajo]

@@ExcelGoogleSheets just learned that =IF(1,,)="" returns TRUE, kind of weird, as you showed up those are different for counting. Thanks for the insight.

[@ExcelGoogleSheets]

That makes sense, because =A1="" returns true when A1 cell is actually blank.

[@samikhal5455]

Thanks!!!!

[@samikhal5455]

I subscribed !!

[@ExcelGoogleSheets]

Thank You!

[@lpanebr]

I can't believe I've never tried that! 🤦

[@lpanebr]

This fixes a HUGE immensely annoying problem when you use a script with appendRow on sheets that have an arrayformula!!!! The row gets appended after all "blank" rows.

[@ExcelGoogleSheets]

:)

[@ExcelGoogleSheets]

Not too many people notice these details.

[@lpanebr]

@@ExcelGoogleSheets :-)

[@helmanfrow]

Too bad there's no way to do this in Excel without VBA.

[@AlexanderAbramovNN]

Good lesson! Unfortunately, this method does not always work, for example, with =REGEXREPLACE(A1;"[\W]*"; ) , returns a non-empty cell (=CELL("type";B1)) "= l" - text).

[@ExcelGoogleSheets]

That has nothing to do with this method. REGEXREPLACE function will always return text. You can say =IF(REGEXREPLACE(A1;"[\W]*"; )="",,REGEXREPLACE(A1;"[\W]*"; ))

[@AlexanderAbramovNN]

@@ExcelGoogleSheets thanks, i already solved with filter function and regexmach like this : =UNIQUE(filter(A:A;REGEXMATCH(A:A;"\w")))