I wish even one of my teachers back in my schooldays had had your level of imparting complicated knowledge in such a well explained fashion. Thank you once again.
@ExcelGoogleSheets2 жыл бұрын
Wow, thank you!
@ExcelAZ2 жыл бұрын
Interesting! Filter and N combination in Google sheet 💝.
@nurserytoys2 жыл бұрын
#Excellent #Excellent #Excellent _Sir Your Explanation is Awesome_ *_i am Your GoogleSheet Admirer(Fan) , More Than 4 years ago_* *LoveYouSir*
@nurserytoys2 жыл бұрын
in my old mobile phone.
@ExcelGoogleSheets2 жыл бұрын
👍
@Dexcelo2 жыл бұрын
Thank you very much for the great explanation !!
@ExcelGoogleSheets2 жыл бұрын
Thanks for watching!
@eduardorivera47202 жыл бұрын
Me encantan estos videos aprendo bastante, aunque la barrera de entrada sea el lenguaje, me gustaría que estos videos tuvieran subtitulos en español para que pudiera llegar a más usuarios, ya que en lo particular entiendo únicamente viendo, pero no estaría de mas leerlo ya que siempre puede que haya algo que no percibimos.
@vishaldoiphode072 жыл бұрын
❤Thank you so much, You are pro.i learnt many things from you
@ExcelGoogleSheets2 жыл бұрын
Thank You!
@hamvasq Жыл бұрын
Thanks!
@ExcelGoogleSheets Жыл бұрын
👍
@motogoa2 жыл бұрын
Very neat method, thanks!
@ExcelGoogleSheets2 жыл бұрын
👍
@paulhitchman23122 жыл бұрын
This is cool but I think it works in Sheets without the N and N* function... just use (,) and keep adding logical tests. Anyway thanks this was very very helpful with the spill function for duplicates. Just what I was looking for.
@ExcelGoogleSheets2 жыл бұрын
Correct, but I like my spreadsheets compatible for both if possible.
@Allen-L-Canada2 жыл бұрын
multiple condition very useful! Also N() is new to me.
@ExcelGoogleSheets2 жыл бұрын
👍
@richardhay6452 жыл бұрын
your title said you would do it with XLOOKUP!!. Also it is unhelpful to do Sheets, Exce. for windows, Excel for Mac and Excel OnLine in one video. PICK A LANE at least for a single video. BTW: N functions; SERIOUSLY? As an Excel desktop 365 user I NEVER use N functions. Make it clear to your viewers that Microsoft created N functions only for compatibility with other programs.
@ExcelGoogleSheets2 жыл бұрын
The point is that you wouldn't use XLOOKUP or VLOOKUP, that's what people think they should use. Also N function rocks. It serves as a great wrapper function instead of just using bunch of nested parenthesis that make things confusing. Doesn't really make any difference why Microsoft created it. It's a quick and reliable way to convert true/false to 1/0.
@richardhay6452 жыл бұрын
@@ExcelGoogleSheets title TOTALLY deceptive regardless of their efficacy. FILTER handles TRUE/FALSE just fine on its own. I use FILTER regularly and often as a lookup function and never have needed an N function to improve efficiency.