After your last video you inspired me and this was what I was trying to do (unsuccessfully). I was trying to look up the latest sell price of each stock I had sold. This will work perfectly. Excellent teaching and content as always. Thank you!
This is probably what I need to pull the LAST response from a given student when I have them fill out their weekly reflection in a form. I did it another way but I like this way better. I could see using this a lot when dealing with duplicate rows and wanting to get the most recent data.
You all probably dont care at all but does anybody know of a method to get back into an Instagram account?? I stupidly lost my login password. I love any assistance you can give me!
Thank you so much! With lookup i can discover when my client first visit us. Now with this video i can know when is the last time that client visit us.
Omg, thank you so much. You responded to my question. I made a donation on your website and I will probably sign up for your online courses. Please keep up the good work 🙏
Great job! This is by far the best explanation of how to do this I have found. The steps are logical and well explained. Many thanks. I have subscribed and definitely will watch for your other videos.
Was having troublr with sumproduct func, I just used countif func since it does the same thing just do =COUNTIFT(range,what you want) in my case, =COUNTIF(D:D,"Deposit")
Hello, this is very useful. But I have a similar case where there are values (in place of names) corresponding to TAGs (instead of Co Ids). Is there any method to find the least value instead of the last name. Appreciate if someone could give some answer.
Thanks for your amazing videos If I want to find the next match? how do i do it with the index(filter.....)) formula? any sugesstion. I was able to get all the matches using textjoin(index(filter) but I want use get the next result... any suggestions plz?
Thanks for the video. Your channel has been super helpful. I’m trying to pull the names up of all the employees along with which department they’re part of in a join function. I’m using the filter function to get all the people of a given company. I’m trying to get a result like this to be all in one cell... “Mike [Advertising], Becky [Advertising], Phillip [Advertising].” But I’m getting a result like... “Mike Becky Phillip, Advertising Advertising Adverising” I’m using a combination of the join and filter functions because I want every person name and department in the same cell. I was wondering how would you go about this and adding “ [ ]” signs to make it easier to read when someone is reading it. Thanks!
ttnaks...that's best trick...but do you have video "find last product, but dynamic in unlimitid couloum"?, i mean, sumproduct can not work on arrayformula, so it can not work to unlimited coloumn...thanks before..
i have multiple of the same date and want to find the last one. but my sumproduct fucks up. it gives me an error. "function split parameter 1 value should be non-empty"
Hi, thank you for this video. But this doesn’t dispatch the first matching value. It only works if it’s more than one matching value. Please help! I hope to hear back
Hi Sir. I have a list of Lot Numbers in excel sheet 1. I want to look up the pictures saved in a folder with the same Lot Numbers and bring them on Sheet2 in separate cells. Is it Possible in excel or Google sheet?. For Google sheet, I can Save Pictures in GDrive.
@@ExcelGoogleSheets thank you so much for replying, i have searched for days on google and youtube but I didn’t fined any way to do this, if possible and have time please recommend a video or you can assist me with this problem by creating a video tutorial. Thank you so much sir.
![Lookup the Last Value in Excel [XLOOKUP & INDEX / MATCH]](http://i.ytimg.com/vi/c9OCwDXGg4Y/mqdefault.jpg)
This was super helpful, exactly what I needed! THANKS SO MUCH!
been trying to find out how to do this for the longest time and finally managed to do it thanks to you. thank you!!!!
This video was the perfect solution to my issue. Your guidance is so clear and concise. Thank you for all the effort you put into your videos.
I really appreciate your video. It helped me. Thanks
🔥👍👍👍 Your instructions are clear and educational, you've helped me a bunch of times. Thank you very much!
Thanks, this helped. I prefer to use countif instead of sumproduct for readability to get the last number
After your last video you inspired me and this was what I was trying to do (unsuccessfully). I was trying to look up the latest sell price of each stock I had sold. This will work perfectly. Excellent teaching and content as always. Thank you!
Cool!
This is probably what I need to pull the LAST response from a given student when I have them fill out their weekly reflection in a form. I did it another way but I like this way better. I could see using this a lot when dealing with duplicate rows and wanting to get the most recent data.
You all probably dont care at all but does anybody know of a method to get back into an Instagram account??
I stupidly lost my login password. I love any assistance you can give me!
Thank you Brother! Very Helpful!
Thank you so much!
With lookup i can discover when my client first visit us.
Now with this video i can know when is the last time that client visit us.
Wonderful!
really awesome video
Omg, thank you so much. You responded to my question. I made a donation on your website and I will probably sign up for your online courses. Please keep up the good work 🙏
What is his website? I would be happy to donate something for his amazing contribution. This video really solved my problem.
@@rajvlog7848 www.chicagocomputerclasses.com/youtube-learn-google-spreadsheets/
I found it on this channel description, on the 'About' tab
Cool as always, thumbs up. Also you can use sort(filter()) but must be have structured unique parameter
Solved my issue. thanks.
exactly what I need!
This video help me a lot. Thank you! BTW, how to combine this formula with the arrayformula?
Insted of doing whatever thing you did chosing the index, its enough just to wirte in the index =INDEX(FILTER, CONTARA(FILTER)) and that's it
nice video! really useful :D
I love All Videos
Great job! This is by far the best explanation of how to do this I have found. The steps are logical and well explained. Many thanks. I have subscribed and definitely will watch for your other videos.
Awesome, thank you!
I LOVE YOU!
Pardon it’s just my suggestion: may be next time you can share a simple ERP (or advanced one) built on google sheet.
Thanks a lot...
Thanks a lot.
Thank you Very much. You have solved out my one of the Problem
👍
tHANKS A LOT
Was having troublr with sumproduct func, I just used countif func since it does the same thing
just do =COUNTIFT(range,what you want)
in my case, =COUNTIF(D:D,"Deposit")
This is great - what if we wanted to do the most recent date rather than the last entered value?
very important thing
I use SORT+VLOOKUP to get the LATEST not the LAST matching value.
Latest according to dates for example.
Hello, this is very useful. But I have a similar case where there are values (in place of names) corresponding to TAGs (instead of Co Ids). Is there any method to find the least value instead of the last name. Appreciate if someone could give some answer.
Thanks for your amazing videos
If I want to find the next match? how do i do it with the index(filter.....)) formula? any sugesstion. I was able to get all the matches using textjoin(index(filter) but I want use get the next result... any suggestions plz?
Thanks!
Thank You!
Teacher...you always make it look so easy!? LoL
P. S. ... Gave up on my Project finally, just couldn't get over the last little piece :(
Thanks
Thanks for the video. Your channel has been super helpful.
I’m trying to pull the names up of all the employees along with which department they’re part of in a join function. I’m using the filter function to get all the people of a given company. I’m trying to get a result like this to be all in one cell...
“Mike [Advertising], Becky [Advertising], Phillip [Advertising].”
But I’m getting a result like...
“Mike Becky Phillip, Advertising Advertising Adverising”
I’m using a combination of the join and filter functions because I want every person name and department in the same cell. I was wondering how would you go about this and adding “ [ ]” signs to make it easier to read when someone is reading it.
Thanks!
You'll have to combine your columns and squre brackets with "&" and then do JOIN to comma separate the results.
@@ExcelGoogleSheets thank you. Was able to figure out with the point in the right direction.
ttnaks...that's best trick...but do you have video "find last product, but dynamic in unlimitid couloum"?, i mean, sumproduct can not work on arrayformula, so it can not work to unlimited coloumn...thanks before..
will this work with arrayformula ?
how to implementation for google script on submit trigger?
How to use arrayformula for this?
Can this work within the same sheet? Or does it need to be between sheets?
same sheet is fine.
How to achieve the same thing on an arrayformula vlookup?
Why not use countif rather than sumproduct here? 5:51
i have multiple of the same date and want to find the last one. but my sumproduct fucks up. it gives me an error. "function split parameter 1 value should be non-empty"
I use query function with Desc Limit 1.
Not the same thing.
Thank you Sir. I learnt so much from your videos. Best google sheets video in youtube 👍
before the last payment date and amount show in excel 2016
Isn't possible to put arrayformula with this function, so no need to copy paste the formula in multiple row
Hi, thank you for this video. But this doesn’t dispatch the first matching value. It only works if it’s more than one matching value. Please help! I hope to hear back
Use this ruclips.net/video/kt8nUzyKj-A/видео.html
Thank you for your explanations! Couldn't catch what does '--' mean?
converts TRUE to 1 and FALSE to 0
@@ExcelGoogleSheets Thanks a lot!
video starts at 4:10
can you do this in "NUMBERS" - cant find FIlter function
If you need the last match use XLOOKUP ruclips.net/video/kt8nUzyKj-A/видео.html
Hi Sir. I have a list of Lot Numbers in excel sheet 1. I want to look up the pictures saved in a folder with the same Lot Numbers and bring them on Sheet2 in separate cells. Is it Possible in excel or Google sheet?. For Google sheet, I can Save Pictures in GDrive.
Definitely possible with Excel, it's probably also possible with Google Sheets, but this could vary depending on access level on those pictures.
@@ExcelGoogleSheets thank you so much for replying, i have searched for days on google and youtube but I didn’t fined any way to do this, if possible and have time please recommend a video or you can assist me with this problem by creating a video tutorial. Thank you so much sir.
Is it possible the SUMPRODUCT formula change with COUNTIFS formula? Since it's gives how much what we searched
Yes. It's in the end of the video, I've added a note on the screen.
@@ExcelGoogleSheets alright, I missed that note apparently, thank you very much! Your explanations are awesome, simple but comprehensive!
put practiced file in the description
Index(filter(.....), count(filter(.....)))
Hi
I want to learn app script
Please help
ruclips.net/p/PLv9Pf9aNgemv62NNC5bXLR0CzeaIj5bcw
Very happy 😍💋 💝💖♥️❤️
Teacher...you must lay awake at night figuring this stuff out!!!
Usually sit awake instead of lay awake :)
@@ExcelGoogleSheets
Funny! 🤣
Teacher...what did you think of my Formula? I never thought I would be able to put something like that together!!!
why sumproduct instead of just sum?
with sumproduct you don't have to wrap it in arrayformula
I think we can go with xlookup here to get the final match