Can't thank you enough! Since last 12 hrs, I was scratching my head to understand this and have gone through many articles and videos but couldn't get anything more clear! You have saved my day! Good luck!
Wow, this was SUPER helpful!! Thank you for making and posting this, it worked perfectly for what I needed. I used mine to populate a list vertically by counting the rows instead of columns, and it came through exactly as you showed otherwise. The helper column is genius! Thanks again!
sorry to be so off topic but does anyone know of a method to get back into an instagram account? I stupidly lost the account password. I love any assistance you can offer me.
Helper column or row is much easy to use and helpful. One thing we can do is to make the array into a table is by selecting the existing table array and press CTRL+T; so even when the data expands the formula with the helper column, automatically takes care of it. Problem with array is that if the data changes one can not delete any part of the array formula and has to do the things all over again. Fantastic :)
You Sir....are a savior and won a subscription. I had almost the same problem like the video you presented and was trying to figure it out, i thought that it was match, find or other non-sens and all this time it was old friend Vlookup....
The second formula is a bit complicated for me but I know it is largement applicated in many cases and apparently it is very useful. Thank you for your excellent explication !
Nice tutorial, unfortunately was not able to find this tutorial when I needed this I have used TRANSPOSE(FILTER) to do the same thing and it works like a charm.
I love your channel! Thank you so much. I don't know if it was discussed here, but now, with Excel 365, using the XLOOKUP function, you don't need to use the IFERROR function in the "helper column way".
Good video for learning how to write long and complicated formulas. But the problem explained in this video can be resolved through Pivot Table without much fuss of any complicated formulas.
Hello Sumit, thank you very very very much. It's exactly what I've been looking for. I mean the first part of the video. John1, John2, John3... I needed it for an interrupted sequence. Sumit, 1 question: Do you work for UpGrad?
Really helpful. Get to know few shortcuts and particularly use of Columns() formula while concatenating with name in the Helper column was new to me. I keep playing around with Excel formulas and today got some good learning from your video. I hope i can use these learning in creating videos for my RU-vid channel Tech Reflections. Thanks for this helpful video.
You could have used a combination of transpose + filter + if formula rather than using an array formula which could have not even required iferror function and very easy to use. But explained really well. 👍👍
Is there a way to do this between two dates? For example, in Column C, you add the dates next to each training that was done. In cells I1 and J1, you add the start and end dates, respectively. And then in E2 of your example, you add an element to the formula to find which training John did between the dates listed in I1 and J1.
Sumitji, simply superb. Please suggest if it can be done using power query and n how? We would be eager to see your tutorial on this. Thanks in advance.
thanks for your reply, i have checked the uploading frequency of videos on your channel is more of excel stuff, i appreciate your knowledge and sample sources you have been releasing on channel. it would be more helpful to see more of vba part as well.