Last 50 Posts on Chandoo.org

Raminder on 2024-12-11 02:27:32
Hi Chando, thanks for doing this. I have one request, can you show us how to historical values of our individual/total portfolio to track its performance with the benchmark? Again, thanks for your help.

Amit on 2024-12-05 02:52:59
Hi Sir, I have seen your video while browsing for online excel classes in youtube. Earlier, I was a part of Admin team where I was taking care of day-to-day activities. But it's been few months that I have been moved to Data mining, research and analytics. I have been doing everything in excel by creating pivot however, it's been few months that I have been getting feedback for automating the things and structure the data into Dashboard. I'm really struggling now but don't want to give up. Can you please suggest how can I learn Advance Excel, Power Bi, SQL and VBA. I can devote time but want to learn things quickly. Please help. looking forward to your response. Thank you.

Jack on 2024-12-04 02:22:14
can you submit again

Rachael Hanna on 2024-12-03 22:22:45
Your wife is a genius (but I guess you already know this! :-) )

Hasan on 2024-11-10 18:39:53
First I used replace function to free resource type with not required text and value, then used v look formula to get the billing rate Resource Description Billing Rate Correct Answers Nothing CM xxxx4607 CM 120 120 Few things CXO xxxx5633 CXO 250 250 Lots of things RM xxxxxx6378 RM 150 150 Something AM xxxx9132 AM 50 50 One thing AM xxx5299 AM 50 50 Few things PM xxxxx5502 PM 60 60 Nothing AM xxxx6096 AM 50 50 Another thing RM xxx7837 RM 150 150 Something AM xxxxx6719 AM 50 50 One thing FM xxx1817 FM 75 75 One thing CXO xxxxx2823 CXO 250 250 Nothing AM xxx5155 AM 50 50 Another thing FM xxxx3012 FM 75 75 Something AM xxx2124 AM 50 50 Nothing CM xxxx9363 CM 120 120 One thing CM xxxx2104 CM 120 120 Nothing FM xxxxx1386 FM 75 75 Another thing PM xxx9637 PM 60 60 Few things PM xxxx8157 PM 60 60 One thing PM xxxxxx9699 PM 60 60 Few things RM xxxxxx8637 RM 150 150 Lots of things RM xxxxxx3863 RM 150 150 Something CM xxxxx4671 CM 120 120 One thing CXO xxxx2450 CXO 250 250 Nothing PM xxxx1759 PM 60 60 Something RM xxxx8382 RM 150 150 Something PM xxxxxx8054 PM 60 60 Another thing CXO xxxx1293 CXO 250 250 Something RM xxx4545 RM 150 150 Something RM xxxxxx7317 RM 150 150

ariel chocobar on 2024-11-10 15:27:37
hello Chandoo, I have been following you on youtube since 2022, you are awesome. There is one thing about grouping on pivot tables when it comes to month, if the dates are from different years, on the list Excel will not show the year of the month. you have to add another level. I want to group by month and I need Excel to show me the year in the same line as the month, but I am afraid it is no possible in Excel. Regards Bro Keep it up

Abhishek on 2024-11-08 21:27:08
Hi don the workbook not available the site is down I have some of your excel file please upload all I like your work very much

Barun on 2024-11-06 15:37:39
Hi !! I am getting this error - mdxscript(model) (3,35) calculation error in measure : the function sum cannot work with values of type string. This is from your free Power BI course on Youtube 9th video 59th Min. How can this be resolved. I downloaded the sample files present in the description.

FB on 2024-11-05 00:43:26
This is not an interactive tooltip. This is a page with a custom tooltip.

Kannan Ramanathan on 2024-10-31 17:39:03
Hi Chandoo Varsha (my wife) and I wanted to wish you and your family Happy Diwali. t was great meeting you in London earlier this year. Best wishes. Kannan

Monil on 2024-10-30 03:08:29
Hi Chandoo, I am also getting the same error. I am using Office 2019. Would you be able to recommend a fix for this? Regards,

Aman S. Aneja on 2024-10-29 12:56:38
I think with the new rupee symbol and the decimal places. It should be as below: [>=10000000]"? "##\,##\,##\,##0.00;[>=100000]"? " ##\,##\,##0.00;"? "##,##0.00

VENKATESH VUPPULURI on 2024-10-26 17:07:30
Namaste, You have prepared a wonderful excel sheet for benefit of all of us. Many Thanks. I cannot Find the fund: "Edelweiss midcap 150 momentum 50 index fund direct growth" in the excel sheet. Please help!

Diva on 2024-10-26 00:13:33
Hi Chandoo, Thanks for the excel sheet for managing the MF at one place. It is awesome. I find the file is becoming very slow to work on it. Will it be due to refreshing each time? and background process? Request a solution please. Thank you in advance.

Mark on 2024-10-23 09:47:37
Is it possible to add a filter in the Calendar Any Month View? Ex: if I want to show only the EVENTS with TYPE Birthdays.

vinod on 2024-10-12 19:21:52
<> can you elaborate on this? I am getting a semi-colon csv kind of data in one single column. if i use text to table i am unsure if the data is refreshed when i want to get fresh data from the amfi site. thanks for your help. -vin

Aalish on 2024-10-11 19:27:47
According to Chandoo, embedding Excel files on your website can enhance user engagement and provide a seamless experience for users who need to access and manipulate data. With this guide, you'll learn the steps to easily embed your Excel file on your website and start enhancing user interactions today!"

Amedeo on 2024-10-11 11:01:27
Perfect!

Mun Patel on 2024-10-09 09:26:56
Hello When I am entering "Years Invested for" annualized Rate of return is not generating

anushree on 2024-10-08 17:05:12
this is just great ! will it generate 700 all different random tickets? i need that many

Ruchit Rawat on 2024-10-08 15:42:00
What a creative and engaging way to celebrate India’s World Cup cricket victory! The Excel dashboard style adds a unique twist that makes the data and insights so much fun to explore. I appreciate how you’ve highlighted key moments and statistics, making it easy for readers to relive the excitement of the tournament. This post not only honors the team's achievements but also showcases your innovative approach to presenting information. Fantastic job—can’t wait to see more of your creative takes!

Garvit on 2024-10-08 11:21:19
This guide is a fantastic introduction to VBA in Excel! I love how you break down the concepts of macros, variables, and loops. Your step-by-step approach makes it easy for beginners to follow along and start automating tasks!

Subhan on 2024-10-02 15:41:36
Great examples But I have a small query in example#5, If we replace the value of bonus 2% with "4% bonus for others, 1% for website and 3% for sales staff and joined in 2018" How can we solve this with boolean concept?

Chandoo on 2024-10-01 02:23:00
Take out the $ Try =6.45*(c2/60)

harsh on 2024-09-30 13:44:24
sir, i needed an excel formula for identifying prime numbers, i found it on your website, and its working :) kindly accept my gratitude for the same, wishing you flying colours for future endeavors ...

David N on 2024-09-27 16:31:31
Another nuance or potential factor is that we may not consider the first day of a month/quarter to be part of the first week of that month/quarter if it falls on a Friday or Saturday (maybe not even a Thursday). In other words, in some contexts, we might expect a week to contain a certain number of days to be counted as an actual week in a given period. And if we are operating in a business context, then it might even be a minimum number of weekdays. Consider November 2024 as an example where the first day is a Friday. Would we say that November 1 and 2 are part of the first week in November, or would we say they're really part of the last week in October? In such cases, a formula like this one, using 3 as the minimum number of weekdays to constitute a week and "focal" as the date in question, could provide an adjusted week number. =LET( focal,DATE(2024,11,2), minday,3, dayone,EOMONTH(focal,-1)+1, firstfri,WORKDAY.INTL(EOMONTH(dayone,-1),1,"1111011"), wknum,ISOWEEKNUM(focal)-ISOWEEKNUM(dayone)+1, out,IF(NETWORKDAYS(dayone,firstfri)<minday,wknum-1,wknum), out ) With November 2 as the focal date, this formula returns 0 to indicate the date is actually part of the final week of the previous month. If focal were DATE(2024,11,18), then the answer would be 3. A variation on this idea would be wanting to know the date of the Friday in the second week of August. Not the second Friday in August, but the Friday of the second week in August. For 2024, that would be August 16. =LET( dayone,DATE(2024,8,1), minday,3, weekend,REPLACE("1111111",5,1,"0"), firstfri,WORKDAY.INTL(EOMONTH(dayone,-1),1,weekend), target,WORKDAY.INTL(EOMONTH(dayone,-1),2,weekend), out,IF(NETWORKDAYS(dayone,firstfri)<minday,target+7,target), out )

Octavian on 2024-09-26 16:32:55
=IF(C13>3%,0,IF(C13=0%,1500,1000))+IF(OR(E13<500,F13=1,1000,0)+IF(D13>=98%,1500,IF(D13>=96%,500,0))

Octavian on 2024-09-26 16:32:11
Here is my formula:

Chale on 2024-09-26 03:13:16
Helo..my computer is saying that it is not a formula that im trying to enter...my formula says =$6.45*(C2/60) whereC2 is 12

Neha on 2024-09-24 11:11:57
Thank you for sharing such valuable insights on VLOOKUP, INDEX, and MATCH functions! Your explanations make it easy to understand how these tools can enhance data processing skills in Excel. I appreciate the examples and resources provided for further learning!