I was looking for a formula for the second highest value in a filtered list more than a week now! I just knew I had to use the index function somehow :) But I could not wrap my head around to combine 3 functions for that. Excellent, thank you so much for the video!
I learned a lot from this video. Say I wanted to create a level system (flight/tier system) with top 4 being in Tier 1 (I've already got a formula for top 4 and bottom 4), but what about pulling data from the middle of a data set, like I need the 5th-9th highest X, then the 10-13th highest X, etc. How would I set up that formula in Google Sheets?
Sir your video was helping me alot, thanks!! 1 question, what formula can i use for trying to lookup a data by id reference but the data to lookup have more string (not exactly the same data) than the reference table? in example my reference table is Nike Shoes $200 Adidas Shoes $190 and then the search key is Buy Adidas Shoes in the holiday (formula to lookup value for return the $190) (search key to refer is "Adidas Shoes") or i can say how can i find the value using vlookup when the search key is have more string then the range table? thank you and sorry for my bad english
Is there a way to make the JOIN function add new data in the next row instead of it continuing adding data in the current row indefinitely? I’m joining names of people in a company and their department. The result I’m trying to achieve is that I want it to join say 5 names and departments together but then the next ones will be on a new row. Every five would be a new row. Was wondering if achieving such a result is possible with JOIN function or some other method. Not sure how to look it up, so I was wondering my if you knew how to tackle this. Thanks again! Your videos have been real helpful!
problem in webapp crud part 6 hey great video btw, i am running the search by auto populating the current date so when ever i open the search box it fails to work casue as mentioned in the beginning of the video it takes time for the script (ig) to get the data from the sheet, i did use set timeout and it did work but this seems like a wrong way to solve this problem, is there any way to know when the data is ready so that the search operation can wait until the data is ready
Would you please make a training video about converting digits to texts in sheets? Like a check issued by a bank or a merchant which shows the amount in numbers and text as well. Thank you
What I was trying to say is that this is not going to work with an array formula. There might be other ways to get the highest and lowest value with an array formula using QUERY & VLOOKUP, but not 2nd, 3rd, 4th.
Once again, incredibly useful. I also never realised the full functionality of the sort function until now. Thank you!
Great to hear!
I was looking for a formula for the second highest value in a filtered list more than a week now! I just knew I had to use the index function somehow :) But I could not wrap my head around to combine 3 functions for that. Excellent, thank you so much for the video!
Thank you very much for this. You saved my day
I learned a lot from this video. Say I wanted to create a level system (flight/tier system) with top 4 being in Tier 1 (I've already got a formula for top 4 and bottom 4), but what about pulling data from the middle of a data set, like I need the 5th-9th highest X, then the 10-13th highest X, etc. How would I set up that formula in Google Sheets?
Very helpful 👍
How do i do this using app script? Because it seem to be slowing down sheet processing of used this way.
I really hope to hear back. Thanks
Teacher...watched this Video several times. Good Stuff!!!
Question though...wouldn't the SMALL Function do the same thing?
Thanks!
No Teacher...Thank You!!!
Sir your video was helping me alot, thanks!!
1 question, what formula can i use for trying to lookup a data by id reference but the data to lookup have more string (not exactly the same data) than the reference table?
in example
my reference table is
Nike Shoes $200
Adidas Shoes $190
and then the search key is
Buy Adidas Shoes in the holiday (formula to lookup value for return the $190) (search key to refer is "Adidas Shoes")
or i can say how can i find the value using vlookup when the search key is have more string then the range table?
thank you and sorry for my bad english
Is there a way to make the JOIN function add new data in the next row instead of it continuing adding data in the current row indefinitely?
I’m joining names of people in a company and their department. The result I’m trying to achieve is that I want it to join say 5 names and departments together but then the next ones will be on a new row. Every five would be a new row.
Was wondering if achieving such a result is possible with JOIN function or some other method. Not sure how to look it up, so I was wondering my if you knew how to tackle this.
Thanks again! Your videos have been real helpful!
Doesn't sound like it's going to work.
Thank you!
The problem may come when there is repeated max in column to be sorted and then this way should be changed to filter and join function approach.
Good point.
problem in webapp crud part 6
hey great video btw, i am running the search by auto populating the current date so when ever i open the search box it fails to work casue as mentioned in the beginning of the video it takes time for the script (ig) to get the data from the sheet, i did use set timeout and it did work but this seems like a wrong way to solve this problem, is there any way to know when the data is ready so that the search operation can wait until the data is ready
I have 3 datasets in really struggling to merge. Would you be able to have a look at it for me please?
Would you please make a training video about converting digits to texts in sheets? Like a check issued by a bank or a merchant which shows the amount in numbers and text as well. Thank you
There is one on the channel already.
Thank you
Thanks for watching!
Thanks!
Thank you!
I’m trying to make it return multiple column. Please help!!
Thanks you sir
Expertly-dictated vidoe - much obliged.
Hi 👋
How can I do this as an arrayformula?
Probably not.
@@ExcelGoogleSheets why not?
=arrayformula($K41:K=IF($B2:B="","",(ARRAYFORMULA(LOOKUP(2,1/(TEXT(B$2:B,"mmmyyyy")=TEXT(K41,"mmmyyyy")),E$2:E)))))
Look at the formula, after TEXT=K41, I have k42,k43,k44 etc. I need an arrayformula
@@ExcelGoogleSheets think 🤔, help me
What I was trying to say is that this is not going to work with an array formula. There might be other ways to get the highest and lowest value with an array formula using QUERY & VLOOKUP, but not 2nd, 3rd, 4th.
talks too much. just jump to the point