@@chandanakollu2555I practiced along with the video playing on my second monitor. I started with the beginner to advanced data analyst playlist on chandoo’s channel. Kept on practicing by downloading Awesome chocolates dataset. Then I headed over to power Bi course on his channel. It helped me in learning how to create attractive looking dashboards. It took me around 7 months of consistent practice.
Thanks for the good and very frequently used function. Apart from removing duplicate, you also gave a nugget on how to lookup values meeting multiple conditions using *. I was struggling all the time but its a simple hack.
Thanks Chandoo, I learnt an extension of an existing solution I already have.. I worked with names and latest data scenarios. As of now I am using an intermediate column called Key with concatenation of name and latest date and used lookup to get remaining columns.. now I can use filter..
Quality and educational content, as always. Thanks a lot! Ex4: In case of daily granularity of data I simply would use pattern =FILTER(NamesDates_ ,Dates=MAXIFS(Dates,Names,Names))
Excellent resource for honing your Excel skills! It is clear and informative, greatly speeding up my spreadsheet tasks. This skill boost is sure to be beneficial in career.
Greetings I don't know if you would understand my question and is as follows: How do I handle zeros in spill functions, when it is supposed to be blank, or when my answer is zero or has a zero? 😢😢😢😊
Hello Sir, I need your help. I want a formula that if • if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated • If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated • if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated Please Reply Sir
Are Yaar kabhi to kuch free excel video dala karo, Hamesha aap paisa maangte rahte ho. Aapke video dekhne ke baad mein hi pata chalega ki aapka sikhane ka style kya hain. Uske pahe hum invest kaise kare?
Thanks Chandoo for consistently uploading quality content! You helped me land my first Data Analyst job. Thank you so much!
how did you do it help us in achieving
@@chandanakollu2555I practiced along with the video playing on my second monitor. I started with the beginner to advanced data analyst playlist on chandoo’s channel. Kept on practicing by downloading Awesome chocolates dataset. Then I headed over to power Bi course on his channel. It helped me in learning how to create attractive looking dashboards. It took me around 7 months of consistent practice.
Thanks for the good and very frequently used function. Apart from removing duplicate, you also gave a nugget on how to lookup values meeting multiple conditions using *. I was struggling all the time but its a simple hack.
Thanks Chandoo, I learnt an extension of an existing solution I already have.. I worked with names and latest data scenarios. As of now I am using an intermediate column called Key with concatenation of name and latest date and used lookup to get remaining columns.. now I can use filter..
wow! I have got my answer after watching ur video. Thanks you so much, teacher
Quality and educational content, as always. Thanks a lot!
Ex4: In case of daily granularity of data I simply would use pattern
=FILTER(NamesDates_ ,Dates=MAXIFS(Dates,Names,Names))
Wow, excellent use of the array option in MAXIFS... took me a minute to understand what is going on.
Excellent resource for honing your Excel skills! It is clear and informative, greatly speeding up my spreadsheet tasks. This skill boost is sure to be beneficial in career.
You are amazing Sir
Thanks for sharing, everything you share is valuable in many ways
Vstack is new for me. Thank you. Might use it later in data cleaning.
really practical use cases
Just see the names of the people in the tables. Good one Chandoo 🤣
Thank you, Chandoo, really help.
Sir could you please put video about data scraping which we can use those data for analysis and do some projects
🙏🙏🙏 useful functions👍 Thanks a lot Chandoo Garu
Thanks Chandoo!
Excellent bro 👍👍
Thanks brother.. could you please share any personal budget template
Super chandoo sir ty
Sir do a video on VLOOKUP,HLOOKUP, PIVOT TABLE
needed, searching for it ..
Complete exel video ఒకటి telugu lo chey anna
Greetings
I don't know if you would understand my question and is as follows:
How do I handle zeros in spill functions, when it is supposed to be blank, or when my answer is zero or has a zero?
😢😢😢😊
Can you give me a specific example and what outcome you are expecting?
Hello Sir, I need your help.
I want a formula that if
• if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated
• If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated
• if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated
Please Reply Sir
UNIQUE formula is also available on MS Excel 2021
That is good to hear. I haven't used Excel 2021 but I know XLOOKUP is in there.
How to separate duplicates in another column?
=UNIQUE(FILTER(Names,COUNTIF(Names,Names)>1))
@@ciaucia156 thank u
Are Yaar kabhi to kuch free excel video dala karo, Hamesha aap paisa maangte rahte ho. Aapke video dekhne ke baad mein hi pata chalega ki aapka sikhane ka style kya hain. Uske pahe hum invest kaise kare?