Last 50 Posts on Chandoo.org

Rebecca on 2025-06-27 19:01:01
Is there a way to make it something that is more than a day without having to add it to every day of that week.

William on 2025-06-25 14:59:37
Q1: =COUNTA(FILTER(B:B,(C:C>$K$3)*(D:D=" & start,C:C,"<=" & end)+COUNTIFS(D:D,"=" & start)-COUNTIFS(C:C,">=" & start,D:D,"$K$3)*(D:D<$K$4))))

Chandoo on 2025-06-24 22:08:44
While that idea might work, it creates separate spill ranges for each column. If you need to do something with all the filtered data (such as send it to GROUPBY or VSTACK or count the results), you will have another problem on the hand. I suggest using either choosecols / take / drop / index to create one spill range for all the filtered results.

JI on 2025-06-23 13:58:50
On the sudoku solver, what if instead of 9 numbers the puzzle is 25 number? how would you do it

Al R on 2025-06-20 11:27:08
Hi Chandoo, Thank you for the great lesson and this very helpful application of dynamic arrays in project management. I have an observation and a question: I tested out your example worksheet and the formulas encounter errors if the ID numbers are not in immediate succession starting from 1. I tried a few test cases: First, I added 10 to each ID number, taking care to also update the Predecessors column. I also tried just changing just the ID=2 to 20, also making sure I update the Predecessor's column to match. In each test case, the formulas had some errors. How can the formulas be updated to be able to accommodate ID numbers that are not in numerical order? Often, the tasks in a project might get re-sorted or a task will get inserted later and introduce an out-of-order ID.

Harshiya Banu on 2025-06-20 03:05:12
Will you please send me the pbix. file of this exercise?

Diana on 2025-06-18 15:12:09
Am new here in the platform wanted to learn more as a beginner of excel Microsoft and am in love with your teaching

Jackie William on 2025-06-17 19:58:01
Is there anyway this can turn into an academic calendar (ie. start month is July and runs all the way through June of next year)?

Jesse Lewis on 2025-06-13 21:37:10
I think the syntax seems too confusing. FILTER is great but then having CHOOSECOLS require specificly numerating columns isn't great. Multiple FILTER functions in separate columns > One FILTER function with a weird formula that you go, "how does this work again?" down the road.

Chandoo on 2025-05-30 22:01:00
You can adjust these from the settings tab.

Kalaignan on 2025-05-29 06:30:19
How do we change/insert the customization "Icon Options" ?

Luke M on 2025-05-28 13:52:00
Alternate formula for showing duplicate items: =FILTER(List1, COUNTIFS(List2, List1), "No duplicates")

Fan on 2025-05-27 07:03:17
This Excel document is not working anymore due to the shutdown of this URL: https://www.amfiindia.com/spages/NAVAll.txt. Excel is showing the error like. [Datasource.error] Unable to connect to the remote server even i have try this URL manually and its not showing any data. Thank you

Chick Newman on 2025-05-18 16:47:44
Mr. Walkenbach, I bought your book Excel VBA for Dummies, 2nd edition. There is no way to access the sample files. The URL in the book (www.dummies.com/go/excelvbaprogrammingfd2e) does not work. I would appreciate it if you would send me either the correct url or the actual sample files (to my email). I am using Excel 2010. Thank you. Chick

Chandoo on 2025-05-18 06:21:12
Not possible as this is an interactive chart.

Chandoo on 2025-05-18 06:20:56
You can edit the text in the file

Ram on 2025-05-14 09:30:25
How to add expense Ratio to the sheet

Lizzie on 2025-05-13 09:40:21
Is there a way to change the text of "Select someone" in the selection panel?

Lizzie on 2025-05-13 08:39:48
Is there a way to export this to ppt?

mukesh on 2025-05-10 10:34:16
The Excel formula will match the value in row A having different value with the value in row B different value meet at a close or slightly different value. ()

shahrukh on 2025-04-23 13:54:46
=XLOOKUP(TEXTBEFORE(TEXTAFTER(B4," ",-2)," ",1),$H$4:$H$9,$I$4:$I$9,,0)

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