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.

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

I really appreciate your video. It helped me. Thanks

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!

@ExcelGoogleSheets

3 жыл бұрын

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.

@augustinejay3616

2 жыл бұрын

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!

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

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

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 🙏

@rajvlog7848

3 жыл бұрын

What is his website? I would be happy to donate something for his amazing contribution. This video really solved my problem.

@goukisan2869

3 жыл бұрын

@@rajvlog7848 www.chicagocomputerclasses.com/youtube-learn-google-spreadsheets/ I found it on this channel description, on the 'About' tab

Thank you Brother! Very Helpful!

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.

@ExcelGoogleSheets

Жыл бұрын

Awesome, thank you!

Solved my issue. thanks.

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.

@ExcelGoogleSheets

2 жыл бұрын

Wonderful!

really awesome video

exactly what I need!

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

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?

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

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.

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

@ExcelGoogleSheets

Жыл бұрын

👍

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 :(

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

I love All Videos

I LOVE YOU!

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

tHANKS A LOT

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

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!

@ExcelGoogleSheets

3 жыл бұрын

You'll have to combine your columns and squre brackets with "&" and then do JOIN to comma separate the results.

@divh5206

3 жыл бұрын

@@ExcelGoogleSheets thank you. Was able to figure out with the point in the right direction.

will this work with arrayformula ?

Can this work within the same sheet? Or does it need to be between sheets?

@ExcelGoogleSheets

Жыл бұрын

same sheet is fine.

Thanks!

@ExcelGoogleSheets

Жыл бұрын

Thank You!

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 SORT+VLOOKUP to get the LATEST not the LAST matching value. Latest according to dates for example.

How to use arrayformula for this?

how to implementation for google script on submit trigger?

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

3 жыл бұрын

Definitely possible with Excel, it's probably also possible with Google Sheets, but this could vary depending on access level on those pictures.

@795mehran

3 жыл бұрын

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

very important thing

Why not use countif rather than sumproduct here? 5:51

Isn't possible to put arrayformula with this function, so no need to copy paste the formula in multiple row

How to achieve the same thing on an arrayformula vlookup?

Is it possible the SUMPRODUCT formula change with COUNTIFS formula? Since it's gives how much what we searched

@ExcelGoogleSheets

3 жыл бұрын

Yes. It's in the end of the video, I've added a note on the screen.

@dibmw21

3 жыл бұрын

@@ExcelGoogleSheets alright, I missed that note apparently, thank you very much! Your explanations are awesome, simple but comprehensive!

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

@ExcelGoogleSheets

Жыл бұрын

Use this kzread.info/dash/bejne/nahs0Lezqa7QXaQ.html

Thanks

Thank you for your explanations! Couldn't catch what does '--' mean?

@ExcelGoogleSheets

3 жыл бұрын

converts TRUE to 1 and FALSE to 0

@MyNick0101

3 жыл бұрын

@@ExcelGoogleSheets Thanks a lot!

can you do this in "NUMBERS" - cant find FIlter function

@ExcelGoogleSheets

Жыл бұрын

If you need the last match use XLOOKUP kzread.info/dash/bejne/nahs0Lezqa7QXaQ.html

before the last payment date and amount show in excel 2016

I use query function with Desc Limit 1.

@ExcelGoogleSheets

3 жыл бұрын

Not the same thing.

@LCY888

3 жыл бұрын

Thank you Sir. I learnt so much from your videos. Best google sheets video in youtube 👍

Very happy 😍💋 💝💖♥️❤️

Hi I want to learn app script Please help

@ExcelGoogleSheets

3 жыл бұрын

kzread.info/head/PLv9Pf9aNgemv62NNC5bXLR0CzeaIj5bcw

put practiced file in the description

Teacher...you must lay awake at night figuring this stuff out!!!

@ExcelGoogleSheets

3 жыл бұрын

Usually sit awake instead of lay awake :)

@Puner54

3 жыл бұрын

@@ExcelGoogleSheets Funny! 🤣 Teacher...what did you think of my Formula? I never thought I would be able to put something like that together!!!

video starts at 4:10

why sumproduct instead of just sum?

@ExcelGoogleSheets

3 жыл бұрын

with sumproduct you don't have to wrap it in arrayformula

Index(filter(.....), count(filter(.....)))

I think we can go with xlookup here to get the final match