Last 50 Posts on Chandoo.org

Ramesh Sridhar on 2020-01-26 07:06:23
Chandoo, Thanks for the awesome household budget spreadsheet, can we get something similar for office budget spreadsheet- please. Regards,

Jo on 2020-01-25 16:45:22
Could I get to download the graph example which is displayed in the beginning? Thanks

Raghuveer Charan on 2020-01-25 07:53:45
awesome information thank you so much for sharing

Jack Griffin on 2020-01-23 12:51:27
Whenever i get stuck in Excel, this site is my first port of call :)

Harkesh Sharma on 2020-01-23 06:05:53
Really great, Very well explained. So helpful.

vikas kaushik on 2020-01-22 11:00:08
my file contains multiple sheets need to split all sheets how can it be done please help

Chandoo on 2020-01-21 21:08:46
Thanks Erika. That is ok with me.

Erika Miller on 2020-01-21 15:11:43
Is it okay if we feature your site in our next email newsletter? It's a perfect fit for a piece we're doing and I think our audience would find some of the content on your site super useful. I know you're probably busy, so just a simple yes or no would suffice. Many Thanks,

Sushmita Bhar on 2020-01-21 06:41:11
=INDEX(resRates,MATCH(TRIM(RIGHT(SUBSTITUTE(LEFT(B4,FIND("x",B4)-2)," ",REPT(" ",100)),100)),resTypes,0))

Jaideep on 2020-01-20 14:45:12
Try this ... https://drive.google.com/file/d/1W_tHyDg9DWfaW9rTRJWgY-Z95uOQK6i2/view?usp=sharing

Jaideep on 2020-01-20 14:44:16
Try this ... https://drive.google.com/file/d/1W_tHyDg9DWfaW9rTRJWgY-Z95uOQK6i2/view?usp=sharing

Jaideep on 2020-01-20 14:42:36
Hey Uday, What do you hope to gain by getting your portfolio value at 330pm vs say 930pm? You can't trade in MFs after 330pm anyway. So any decision you take will only be executed the next day, when you have updated NAVs from AMFI anyway. MFs are not for day traders, unless you are trading very large volumes in liquid schemes.

Sushmita Bhar on 2020-01-20 06:12:35
1.=LOOKUP(LARGE(D5:D17,2),$D$5:$D$17,B4:B17) 2.=RANK(VLOOKUP(J12,B5:F17,5,FALSE),F5:F17,0) 3.=(MAX(D5:D17)/LOOKUP(MAX(D5:D17),D5:D17,C5:C17))-(SMALL(D5:D17,1)/INDEX(C5:C17,MATCH(MIN(D5:D17),D5:D17,0)))

Uday on 2020-01-20 03:00:39
I have been looking for something like this but can't download it due to restrictions in my office. I have one query though. My understanding is that this basically fetches the NAV values from the AMFI website for the funds I have invested in and neatly presents the values based on my portfolio. This means that I have to wait for each fund house to provide the NAVs for each scheme to AMFI at the end of the day (whenever the cutoff time is), and then this sheet in turn fetches that from the AMFI website. Question: Is it possible to have this ready right after 3:30 pm when the market closes and calculate the NAV ourselves? For example, if I have invested in Axis Bluechip, I know the names of all the companies in the portfolio and their closing stock prices at 3:30 pm, plus the expense ratios and all other technical information of the fund, so is there a way to fetch them live, calculate the NAV ourselves and get my portfolio values right after 3:30 pm?

S Ansari on 2020-01-19 10:39:16
Hi Sir, I want to link two cell in excel which will be inter-dependent of each other, I can't left blank if another cell has data. Ex. I have two cell named "A1" & "B1", Cell A1 has Vehicle Type - Market & Own, Cell B1 has Freight Amount, now I want to set as : If cell A1 has Market then B1 must have some value and I can't skip it blank.

Denise Konopka on 2020-01-18 17:21:33
When creating an Invoice template in Excel are you able to utilize the auto row height and wrap feature when the cell is a merged cell? I need to have a number of cells merged together to allow for enough space to type in the description of work performed (lets say cells A-D are merged in each row) however it seems that I am unable to utilize the auto format feature. To work around this I have to manually increase the row height after each entry. Is there a better solution for this? Thank you!

Sushmita Bhar on 2020-01-18 08:55:09
solution 1: {=(1-INDEX($H$7:$H$12,MATCH(TRUE,data1>=C7,0)))*C7*$D$5} Solution 2: {=(1-INDEX($H$26:$H$31,MATCH(TRUE,data2>=SUMIF($B$26:B26,B26,$C$26:C26),0)))*C26*$D$24} Solution 3: {=VLOOKUP(INDEX(data,MATCH(MIN(ABS(data-C46)),ABS(data-C46),0)),$G$46:$H$51,2,FALSE)}

Alysa on 2020-01-17 08:55:52
Having read this I believed it wwas extremely informative. I appreciate you taking the time and energy to put this content together. I once again find myself spending a significant amount of time both reading and leaving comments. But sso what, it was still worthwhile!

Sushmita Bhar on 2020-01-17 06:26:18
=IF(AND(COUNT(C4:X4)<=$AA$5,SUM(C4:X4)<=$AA$6),"go","stay")

Sushmita Bhar on 2020-01-17 06:01:23
for identify call receive outside working hour: =IF(OR(TIME(HOUR([@[Call time]]),MINUTE([@[Call time]]),SECOND([@[Call time]]))VLOOKUP(INDEX(working.hours[Day],WEEKDAY([@[Call time]],2)),working.hours,3,FALSE)),"yes","no") for total number of call receive outside working hour: =COUNTIF(calls[outside office hr],"yes")

razzak on 2020-01-16 11:17:24
many many thanks

Anthony Berglas on 2020-01-16 07:46:31
Also have a look at the Spreadsheet Detective. It has been under active development for a long time and is probably the most comprehensive tool. Free evaluation version. Quote this article to get a 10% discount if interested.

Ayush on 2020-01-15 18:40:41
Unable to refresh the data; it says credentials are required to connect to the web source. Using Office 365. Please help. Thanks :)

FactorLoads on 2020-01-15 09:31:22
Thanks for sharing this. This definitely help me to understand finance well. This is a very useful article. I'll definitely return to this site since I want to enter finance world.

Henrik B. Wieder on 2020-01-13 12:36:27
Hi I've tried to get your formula to work, but likelihood / impact 1/1 does not seem to work.

UMESH KUMAR on 2020-01-12 11:25:34
How to change currency in budget template to say ? or ¢?

Luke on 2020-01-11 08:20:03
thanks for sharing doing this shit buddy

Adriana on 2020-01-10 19:51:23
Hi! Could you please help me find a formula to filter by language? Thank you!

Albertan on 2020-01-10 17:34:08
Hello, can you please talk about VBA codes you used for this calendar and their purpose

laxman kulkarni on 2020-01-10 10:30:19
need total excel formula in excel sheet request to send as soon as