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.

@ExcelGoogleSheets

Жыл бұрын

Wow, thank you!

Absolutely love these videos. Thank you!!!

@ExcelGoogleSheets

Жыл бұрын

Thank You!

#Excellent #Excellent #Excellent _Sir Your Explanation is Awesome_ *_i am Your GoogleSheet Admirer(Fan) , More Than 4 years ago_* *LoveYouSir*

@nurserytoys

Жыл бұрын

in my old mobile phone.

@ExcelGoogleSheets

Жыл бұрын

👍

Interesting! Filter and N combination in Google sheet 💝.

Thank you very much for the great explanation !!

@ExcelGoogleSheets

Жыл бұрын

Thanks for watching!

❤Thank you so much, You are pro.i learnt many things from you

@ExcelGoogleSheets

Жыл бұрын

Thank You!

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.

Thanks!

@ExcelGoogleSheets

Жыл бұрын

👍

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.

@ExcelGoogleSheets

Жыл бұрын

Correct, but I like my spreadsheets compatible for both if possible.

multiple condition very useful! Also N() is new to me.

@ExcelGoogleSheets

Жыл бұрын

👍

Very neat method, thanks!

@ExcelGoogleSheets

Жыл бұрын

👍

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.

@ExcelGoogleSheets

Жыл бұрын

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.

@richardhay645

Жыл бұрын

@@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.