Awesome video! What is the most awesome part of the video is how you teach each procedure within a long formula. This is how: You go through each step within the long formula, showing the different ways every step can be written from the long way to the most optimal. In addition to showing how to write it, you quickly show what that part does and how it looks, before continuing with the next part. In a sense, you explain each component so clearly that almost one wouldn’t need to read the several chapters from a book to read about each statement then put several together. Good for you! I’m looking forward to learning more about your videos.
How can we remove duplicate values from Subject along with data transformation. I applied formula TEXTJOIN("@",TRUE,IF(A2:A12=A16,UNIQUE (C2:C12),"")) , but it is not working
This formula saved my life!!
Thankyou bhai, good fast explanation.
Awesome video! What is the most awesome part of the video is how you teach each procedure within a long formula.
This is how:
You go through each step within the long formula, showing the different ways every step can be written from the long way to the most optimal.
In addition to showing how to write it, you quickly show what that part does and how it looks, before continuing with the next part.
In a sense, you explain each component so clearly that almost one wouldn’t need to read the several chapters from a book to read about each statement then put several together.
Good for you! I’m looking forward to learning more about your videos.
Thanks so much! This is the most clearly articulated comment I have ever read in any of my channels comments section! Saved it as a screenshot
Good video and well explained!
You are a legend. Thank you!!
so helpful thank you!!!
Superb sir...... Thanks for update new trics.
thank you, it helps alot!
I use filter for doing combine reverse
Brilliant.
Awesome trick
Superb
Good info on power query part, but instead of IF function FILTER function is much more better and convenient.
How can we remove duplicate values from Subject along with data transformation.
I applied formula TEXTJOIN("@",TRUE,IF(A2:A12=A16,UNIQUE (C2:C12),"")) , but it is not working