I consider myself an expert in Excel and Google Sheet. But always waiting for your videos because you always present something great.
@ExcelGoogleSheets Жыл бұрын
👍
@joaopedrobohrer6241 Жыл бұрын
Sem dúvidas, este e o melhor canal sobre Google Sheets em toda a internet! PARABÉNS!!!
@sabaripandian116 Жыл бұрын
You are great, simple yet effective
@ExcelGoogleSheets Жыл бұрын
Thanks!
@cheskavillanueva5772 Жыл бұрын
Excellent as always!
@ExcelGoogleSheets Жыл бұрын
Thank you!
@lpanebr Жыл бұрын
This is great! It opens lots of possibilities!
@ExcelGoogleSheets Жыл бұрын
Did you check out the MAP video? That should take care of your array problems.
@lpanebr Жыл бұрын
@@ExcelGoogleSheets yes, I did! I was writing a comment but had to stop and forgot. It definitely solves the arrayformula. I used it today. It's orders of magnitude better than array formula! Thanks! I'm also always waiting for your videos.
@LotfyKozman Жыл бұрын
@@ExcelGoogleSheets Lambda helper functions didn't take much care from your side!
@ExcelGoogleSheets Жыл бұрын
@@LotfyKozman I'm not sure what you mean. I covered these months ago, very few people watched them.
@vishaldoiphode07 Жыл бұрын
How can get sum range basis on condition in sumifs If my header match the take range like A:A Please suggest
@ExcelGoogleSheets Жыл бұрын
Why do you have to use the whole column? Just start from A2.
@vishaldoiphode07 Жыл бұрын
@@ExcelGoogleSheets my question not related to this video I want sum range in sum ifs Example- If I have dates in rows city names in columns Rest value is in any number I want to sum numbers on dates criteria & sum range should be matching by headers
@JCEurovisionFan1996 Жыл бұрын
Did you answer my question on how to rank, break ties, and award the highest rank to the largest weight and the process would continue until it is broken, in Excel and Google Sheets?
@ExcelGoogleSheets Жыл бұрын
I don't really understand what you're trying to do.
@bzmin99 Жыл бұрын
Another bomb ass video!! Thank you
@renashbell4317 Жыл бұрын
can you do arrayformula and index-match?
@ExcelGoogleSheets Жыл бұрын
yes. kzfaq.info/get/bejne/gJeTYLFo1NPPiJs.html
@moshebiener4507 Жыл бұрын
This is amazing, however, it seems to not work the other way around: =SUM(C5:XLOOKUP("TEST",C5:C,D5:D,,0)) Any suggestions???
@ExcelGoogleSheets Жыл бұрын
works fine for me. your XLOOKUP must not be finding a match.
@HelenoPaiva Жыл бұрын
Didnt vlookup also return a reference?
@ExcelGoogleSheets Жыл бұрын
Yes
@lpanebr Жыл бұрын
I just found two limitation on my first try! 🤦 1) The returned reference only works on the same sheet. 2) The returned reference does not work on open ranges, so this does not work: XLOOKUP(B13,A2:A9,B2:B9):B
@ExcelGoogleSheets Жыл бұрын
this worked for me, even though I have fewer rows =SUM(XLOOKUP(B13,A2:A9,B2:B9):B1000000)
@ExcelGoogleSheets Жыл бұрын
this works for me as well from different sheet, LOOKUP being the sheet name =XLOOKUP(LOOKUP!B13,LOOKUP!A2:A9,LOOKUP!B2:B9):LOOKUP!B100
@ExcelGoogleSheets Жыл бұрын
Haven't tried these 2 in Excel.
@lpanebr Жыл бұрын
@@ExcelGoogleSheets you'd right about different sheets. I was doing it wrong. But the open ended range really doesn't work. Here's an example: docs.google.com/spreadsheets/d/1iDITuNZ2YiSEzhpwCYshnvmmGHc9yrigbjK_NpccVsA/edit?usp=drivesdk on sheet2
@ExcelGoogleSheets Жыл бұрын
I didn't say it does, but you can go around it but simply using a very large number, like B1000000