Last 50 Posts on Chandoo.org

Varun Sharma on 2025-04-21 09:59:37
Hi, The above solution works well if the reference value is in text format. What to do if the reference value is in number format. Need a solution for the reference value as number format.

Veer on 2025-04-18 11:29:51
This course sounds like a great opportunity to learn VBA at your own pace. The mix of video lessons and downloadable workbooks makes it really practical for building both basic and advanced skills.

Asif Khan on 2025-04-12 10:51:19
Hi, Good evening I have multiple records in data sheet with same key. I want to transfer all those multiple same rows from data sheet to transfer sheet and then mail merged them to a word document as a report. Thank you

Vassileios Agapitos on 2025-04-11 23:39:53
Amazing, thank you Chandoo! I used the Transpose(filter()#) as an intermediate step to prepare my one-to-many options from a tabular format and used your method to read the horizontal lists into drop-down menus. It would be helpful to share along the conditional formatting that you show in the video.

Abizer on 2025-04-11 13:33:54
Hi Chandoo, I was referring to your xlookup-examples file, and in that I saw your formula for Sl. 8 - Who has least sales? You wrote formula =XLOOKUP(0,sales[Net Sales],sales[Sales Person],,1) but I think a more better way would be to write =XLOOKUP(MIN(sales[Net Sales]),sales[Net Sales],sales[Sales Person],,1). This is because your formula would not reliable unless you're specifically looking for a salesperson who has exactly 0 in sales, which is not the same as the least sales — unless 0 happens to be the lowest. Also, the 1 as the last argument means "approximate match in ascending order," which could return wrong results if 0 isn't found.

ghaith on 2025-04-03 05:04:39
=TEXT(FLOOR(C8,7), "mm/dd/yyyy")

ghaith on 2025-04-02 04:51:12
=XLOOKUP(TRUE, ISNUMBER(SEARCH($H$4:$H$9, B4)), $I$4:$I$9)

Krishna Pandey on 2025-03-31 12:57:29
Hey chandoo, I am preparing for power BI and sql interviews.Your videos helped me a lot,truly you are a gem.We dont get such amazing content without an paid subscription.Just wanna thanks and keep it up.

Gabe on 2025-03-20 15:32:22
This is amazing!!! The best I've seen so far!! Is it possible to update it to consider a column for the final date? That way, if an event lasts more than one day, it repeats in the calendar

petteng on 2025-03-19 13:35:11
I use excel dashboard viewed online through sharepoint. Unfortunately it doesn't works

Marco on 2025-03-17 10:39:55
I still use this solution to quickly and easily retrieve the correct results in my dataset. The functioning and end result are still very good. What I was wondering, are there perhaps better standard alternatives available in Excel in the meantime? The Filter formula is known to me, but becomes very complicated if you want to filter and sort in multiple columns (compare it with filtering in a standard table)

Peter on 2025-03-07 07:24:30
What would be the right way to add more Holidays in the Customizations? Inserting rows in the Holiday List causes the blank cells in the calendar to turn Blue.

Sebastian on 2025-03-05 09:04:04
Q1: =COUNTIFS(vacations[Start Date], ">="&start, vacations[End Date], "="&start, vacations[End Date], "=start)*(vacations[End Date]<=end))))

Syak Mwamondwe on 2025-03-04 15:42:11
Dear Mr. Chandoo, My sincere respect and profound love. I have loved this course. It has opened my understanding of the Power Query, its purpose, and use. I intend to master it under your charge. I intend to learn all. From the Pivots, Deep Excell, Mail merging in MS word, Access, Making illustrative professional presentations in PPP, and Power Query and Power BI, and also Dashboards. I want to enroll into your course where a Certificate can be issued if possible. Advise. Of course, I shall be retiring soon as I will be 60 years on 10th April 2028. So, I shall use this professional and practical knowledge in doing a lot of consultancy work. God, bless you. Thank you. S. Mwamondwe

MKopczynski55 on 2025-03-02 12:00:49
Alliteration homework: (much easier these days with the capabilities of dynamic array formulas) =COUNTNONBLANK( UNIQUE( LOWER( LEFT( TEXTSPLIT(C6, " ") ) ), TRUE ) ) <= 1

Asad Rauf on 2025-02-28 16:56:03
Hi Chandoo, First of all, I thank you for this incredible worksheet for CPM. It is indeed a great to the community. Sharing my data for you to see why the LF for activity 7 is 31 instead of 32, whereas the successor for this activity is empty. Below formula is not picking up the MAX value from EF as it is going over by row instead of looking up in the whole column. Appreciate your reply to my query. ID Activity Predecessors Estimated Duration Successors ES EF LS LF Float 1 A 7 3,4 0 7 2 9 2 2 B 9 4 0 9 0 9 0 3 C 1 12 6 7 19 14 26 7 4 D 1,2 8 5 9 17 9 17 0 5 E 4 9 6,7 17 26 17 26 0 6 F 3,5 6 26 32 26 32 0 7 G 5 5 26 31 26 31 0

SOF on 2025-02-27 02:33:46
Hi Chandoo! I attempted solving the hard question no.5 but I couldnt get the right solution, when I checked your answer and tried to execute it, the same error was shown in my tab. I would love to know more about this kind of problems... Thank you so much.

Wasim Mahmud on 2025-02-26 18:12:06
This is a great explanation of weighted averages in Excel! The step-by-step breakdown makes it easy to follow, and the formula examples are helpful. I appreciate the practical approach—a time-saver for complex calculations. Thanks for sharing this valuable insight!

Gabe on 2025-02-26 17:08:52
=COUNTIF(A1:A4,A1) = COUNTA(A1:A4)

Gabe on 2025-02-24 16:44:39
=XLOOKUP(TRUE, ISNUMBER(SEARCH(resTypes, B4)), resRates, "Not Found")

Brennen on 2025-02-15 04:06:30
=IFERROR(IF(INDEX(resRates,MATCH(TRUE, ISNUMBER(SEARCH(resTypes,$B4)),0))=0, "",INDEX(resRates,MATCH(TRUE, ISNUMBER(SEARCH(resTypes,$B4)),0))),"")

clifton murphy on 2025-02-12 02:36:51
how do i edit this to use months instead of years for term? i have a 90 month loan (7.5 years) that i am trying to use with this and it forces me to use 7 or 8 in years.

Kristin Finn on 2025-02-12 01:21:02
Love this calendar... I have highlight planner dates enabled but all dates are blue, is it possible to customize the color based on the type assigned to each date?

Shalini Karipe on 2025-02-10 06:42:34
Thanks for the amazing content, Chandoo Garu!! can I get the pbix. file of this exercise?

Chandoo on 2025-02-03 20:48:32
Can you check again? The date in "planner" sheet should be a proper date. When I tested with 24-apr-2025, it works.

Nitesh on 2025-01-30 05:26:18
Activities of some dates are not getting displayed on "Any month" and "printable calendar" sheets. e.g. Activity of 24 Apr 25.

Chandoo on 2025-01-30 02:33:21
It is. Just use the option for fri & sat weekend (should be 7).

Karl on 2025-01-28 18:08:41
Hey man, I really appreciate your contribution, this template is awesome, I am sure it will help me to plane my financial life, and also to pay debts earlier and create wealth. Thank you!!!

maddalena on 2025-01-15 13:45:57
Hello, this was very useful and clear. I wanted to ask if it could be possible thruogh power Automate, to send the active worksheet via email. I would say i prefer it as a pdf or as a file itself, but even just image of the sheet could be useful. I am very new to this so hope you can help.

Sangeeta Aggarwal on 2025-01-11 13:14:22
I want to create 1200 housie tkts ! Every 6 tickets must use all 90 numbers! And I want to change the background of the tickets! Also , I want to color some of the empty boxes! Is that possible ?