Find Last Matching Value in Excel & Google Sheets

Learn how to lookup the last match in Excel & Google Sheets.

#find #last #match

[ForeverOneThree]

been trying to find out how to do this for the longest time and finally managed to do it thanks to you. thank you!!!!

[harshsoni]

This was super helpful, exactly what I needed! THANKS SO MUCH!

[bayehdesta]

I really appreciate your video. It helped me. Thanks

[kayep]

Thank you so much! I've been searching for this for a while

[charlottehadfield]

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.

[caiokaspary]

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.

[sharitambasco]

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.

[garychadwick]

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!

[ericc]

Thanks, this helped. I prefer to use countif instead of sumproduct for readability to get the last number

[whitehoof]

🔥👍👍👍 Your instructions are clear and educational, you've helped me a bunch of times. Thank you very much!

[goukisan]

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 🙏

[freechanel]

This video help me a lot. Thank you! BTW, how to combine this formula with the arrayformula?

[rudesindojavieracunasanche]

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

[christophertauss]

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.

[nxvnxej]

Thank you Very much. You have solved out my one of the Problem

[hilmanhannan]

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

[MrAwm-kijb]

Cool as always, thumbs up. Also you can use sort(filter()) but must be have structured unique parameter

[Marshark]

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")

[louifanning]

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"

[PrimeBees]

This is great - what if we wanted to do the most recent date rather than the last entered value?